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 does truncate mean in sql?

1002

What is primary key in db?

991

What is sql select statement?

1013

How can we implement rollback or commit statement in a trigger?

1016

What is sql architecture?

1034

What is the use of prepared statement?

995

What is mutating error in pl sql?

1002

What is the order of sql select?

1029

define data blocks ? : Sql dba

968

What are stored procedures used for?

988

What is having clause in sql?

946

Is sql better than excel?

1118

Define join and name different types of joins?

987

What is group by in sql?

1074

How do you create an update query?

947