Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / User Privilege

 

Creates a user named henry and specifies a default and temporary tablespace

SQL> SQL> CREATE USER henry IDENTIFIED BY pass   2  DEFAULT TABLESPACE users   3  TEMPORARY TABLESPACE temp; User created. SQL> SQL> DROP USER henry; User dropped.