How to Create User in Oracle Database?

Create User

 

To create an user you must connect to oracle as sysdba

 

sql> CONN system/password as sysdba; [connect as sysdba]

 

sql> CREATE USER user_name IDENTIFIED BY password DEFAULT TABLESPACE user TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON user;

 

Now give some privileges to the newly created user.

 

sql> GRANT CONNECT , RESOURCE user_name;

 

To connect newly created user :

 

sql> CONN user_name/password

 

To change password :

 

sql> CONN system/password as sysdba; [connect as sysdba]

sql> ALTER USER user_name IDENTIFIED BY new_password ;

 

To Drop the user: ( including all schema objects ):

 

sql> DROP USER user_name CASCADE;

 

 

 

Advertisements