Wednesday 24 April 2013

Create user in oracle and to give the privileges

 Create user in oracle and to give the privileges;




CREATE USER "LA" IDENTIFIED BY LA DEFAULT TABLESPACE "LA"
 TEMPORARY TABLESPACE "TEMP";


User created.


SQL> grant dba to LA;


Grant succeeded.



SQL> alter database default tablespace users;


Database altered.

SQL> create user lor_dev identified by lo_dev;


User created.

SQL> grant connect,resource to lor_dev;


Grant succeeded.
SQL> conn lor_dev/lo_dev
Connected.

SQL> exit


SQL> select username from dba_users;

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,to know the dba users

No comments:

Post a Comment