create user user_name identified by password then grant resource to

how to create user in sql and how to set password for that?

Question Posted / ayan banerjee

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1069

What are the different sql commands?

1078

How can you select unique records from a table?

1086

what are set operators in sql? : Sql dba

1058

how to include comments in sql statements? : Sql dba

962

Is id a reserved word in sql?

1152

Can instead of triggers be used to fire once for each statement on a view?

963

What is pls integer?

1050

How do you use a while loop in pl sql?

1017

How do you update sql?

992

How can you get sql*loader to commit only at the end of the load file? : aql loader

1022

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1164

What is sql indexing?

1016

how to install mysql? : Sql dba

1115

What is restrict in sql?

1122