User Privilege Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. User Privilege
  4. 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.