Using SQL and PL/SQL Authorization Rules

Use SQL or PL/SQL to define custom authorization schemes.

You define the two additional authorization schemes shown below:

• Manages Others – Authorizes users who manage at least one other employee

• HR Reps and Managers Only – Authorizes users who are either an HR Rep or manage others.

The figure shows the Authorization Schemes page in Shared Components, with the two new schemes added to the list.

Description of the illustration add-two-new-authz-schemes.png