Step 8: Optionally, Remove the Components for This Tutorial

Remove the components that you created for this tutorial.

To remove the components: 

1. In SQL*Plus, connect as SYS with the SYSDBA privilege.

   CONNECT SYS/AS SYSDBA
   Enter password: password
   

2. Enter the following DROP statements:

   DROP USER mweiss;
   DROP USER wtaylor;
   

   Do not drop user sec_admin. You will need this user for other tutorials in this guide.

3. In SQL*Plus, connect as user sec_admin.

   CONNECT sec_admin
   Enter password: password
   

4. Enter the following DROP SQL statements:

   DROP ROLE employee_role;
   DROP PROCEDURE sec_roles;
   

5. Connect as user HR, and then drop the HR_VERIFY table.

   CONNECT HR
   Enter password: password
   DROP TABLE hr_verify;
   

6. Exit SQL*Plus.

   EXIT