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;