how to create user in sql and how to set password for that?
Answers were Sorted based on User's Feedback
Answer / ayan banerjee
create user user_name identified by password
then
grant resource to user_name
grant create session to user_name
Is This Answer Correct ? | 21 Yes | 3 No |
Answer / guruswamy
create user <username> IDENTIFIED BY password;
Is This Answer Correct ? | 21 Yes | 6 No |
Answer / satyajit patel
If u later want to change the password then go to the
database where the user is created and write
ALTER USER user_name IDENTIFIED BY new_password;
Is This Answer Correct ? | 11 Yes | 2 No |
What is Data Concarency and Consistency?
how is exception handling handled in mysql? : Sql dba
How many sql statements are used? Define them.
Does normalization improve performance?
how many groups of data types? : Sql dba
how to find 5th row ?
What do you mean by “trigger” in sql?
Why do we use sql constraints?
How do you update sql?
What is the unique index?
Can a composite key be null?
What is trigger in flip flop?