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

how to use like conditions? : Sql dba

1036

What is the difference between sql and t sql?

961

Is sql difficult?

1100

What is the difference between the conventional and direct path loads? : aql loader

1314

What are all the different types of indexes?

1089

What is sql server and ase?

971

What is output spooling in sql*plus?

980

how many ways we can we find the current date using mysql? : Sql dba

1032

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2525

State few characteristics of pl/sql?

928

how can we optimize or increase the speed of a mysql select query? : Sql dba

878

What is a trigger in sql?

1156

What is mutating table error?

1114

How do you update sql?

909

Can we use delete in merge statement?

997