Tutorial: Creating a Secure Application Role

This tutorial shows how two employees, Matthew Weiss and Winston Taylor, try to gain information from the OE.ORDERS table. Access rights to this table are defined in the EMPLOYEE_ROLE secure application role. Matthew is Winston's manager, so Matthew, as opposed to Winston, will be able to access the information in OE.ORDERS.

In this tutorial:

• Step 1: Create a Security Administrator Account

• Step 2: Create User Accounts for This Tutorial

• Step 3: Create the Secure Application Role

• Step 4: Create a Lookup View

• Step 5: Create the PL/SQL Procedure to Set the Secure Application Role

• Step 6: Grant EXECUTE Privileges for the Procedure to Matthew and Winston

• Step 7: Test the EMPLOYEE_ROLE Secure Application Role

• Step 8: Optionally, Remove the Components for This Tutorial