User Privilege Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. User Privilege
  4. Add CASCADE after the users name in the DROP USER statement
If the user's schema contains objects such as tables and so on.

SQL>
SQL> CREATE USER user1 IDENTIFIED BY pass1;
User created.
SQL>
SQL> GRANT CREATE SESSION TO user1;
Grant succeeded.
SQL>
SQL> DROP USER user1 cascade;
SQL>