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 purpose of normalization?

997

How many types of privileges are available in sql?

1286

Explain what is a view?

998

what is query cache in mysql? : Sql dba

993

What are the possible values for the boolean data field?

902

What is sql data?

925

Why do we create views in sql?

1055

What is replication id?

886

What do you understand by pl/sql cursors?

1019

Is like operator in sql case sensitive?

962

What is lexical units in pl sql?

1054

How does sql*loader handles newline characters in a record? : aql loader

987

what does the t-sql command ident_incr does? : Transact sql

1011

What is restrict in sql?

1035

What is the difference between rename and alias?

1270