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 difference between cursor and trigger?

1074

What are different types of tables in sql?

998

Can we connect to postgresql using sql developer?

1003

what is a view? : Sql dba

1092

What is the difference between delete, truncate and drop command?

1151

what is the difference between clustered and non clustered index in sql? : Sql dba

1127

Is progress software supports to ( pl/sql )?

1037

how does a local variable is defined using t-sql? : Transact sql

1013

What is a unique key?

1055

how do you tune the slow running queries in oracle db , explain the methodology

2786

What is sql trigger example?

1061

What does varchar include?

948

what is view? : Sql dba

959

Is time a data type in sql?

906

what are tables and fields? : Sql dba

1055