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 are different types of queries in sql?

1171

What is raid? How does it help storage of databases?

1128

What is pl sql in dbms?

991

Is sql the best database?

1021

Could you please provide oca (oracle 10g) dumps for my certification ?

5239

explain mysql aggregate functions. : Sql dba

1028

Are left and right joins the same?

1155

Can we perform dml in function?

1130

how do you know the version of your mysql server? : Sql dba

1040

What is sqlservr exe?

1028

Which is faster count (*) or count 1?

1088

Can I learn sql in a week?

1118

What is the difference between microsoft access and sql?

1073

What is the need of merge statement?

1092

How to get unique records from a table?

1021