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

At this stage, Matthew and Winston can try to access the OE.ORDERS table, but they are denied access. The next step is to grant them the EXECUTE privilege on the sec_roles procedure, so that the sec_roles procedure can execute, and then grant or deny access, when they try to select from the OE.ORDERS table.

To grant EXECUTE privileges for the sec_roles procedure:  

• In SQL*Plus, as user sec_admin, enter the following GRANT SQL statements:

  GRANT EXECUTE ON sec_admin.sec_roles TO mweiss;
  GRANT EXECUTE ON sec_admin.sec_roles TO wtaylor;