1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

how to create user in sql and how to set password for that?

Question Posted / lalitha

Answers were Sorted based on User's Feedback



how to create user in sql and how to set password for that?..

Answer / 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

how to create user in sql and how to set password for that?..

Answer / guruswamy

create user <username> IDENTIFIED BY password;

Is This Answer Correct ?    21 Yes 6 No

how to create user in sql and how to set password for that?..

Answer / satyajit patel

If u later want to change the password then go to the
database where the user is created and write

ALTER USER user_name IDENTIFIED BY new_password;

Is This Answer Correct ?    11 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

How do I make my sql query run faster?

0 Answers  

Does pl sql work in mysql?

0 Answers  

How does postgresql compare to oracle/db2/ms sql server/informix?

0 Answers  

What is primary key secondary key alternate key candidate key?

0 Answers  

What is a primary key called that is made up of more than one field?

0 Answers  




7. Where would you look for errors from the database design?

1 Answers   Fintellix,

Types of cursors and explanation each of them ?

4 Answers   DELL,

What is an alias command?

0 Answers  

Which function is used to return remainder in a division operator in sql?

0 Answers  

How do you use join?

0 Answers  

Query for second maximum salary in each in each department

15 Answers   DST Global Solutions, TCS,

Can 2 queries be executed simultaneously in a distributed database system?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories