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 oltp (online transaction processing)? : Sql dba

1070

What is update query?

972

Can primary key be changed?

903

What is sqlite used for?

987

Mention what is the plv (pl/vision) package offers?

1098

What is sql server and ase?

1013

What is a constraint? Tell me about its various levels.

1153

Explain the working of primary key?

1087

How do I save a stored procedure?

1000

What is the primary key?

946

what is the command line end user interface - mysql? : Sql dba

978

What is full form of rtm?

1001

What is numeric function sql?

1052

what is auto increment? : Sql dba

1000

what is unique key constraint? : Sql dba

1030