Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / User Privilege

 

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>