11.5.1 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.

Figure 11-19 Two Additional Authorization Schemes Using PL/SQL and SQL

Description of "Figure 11-19 Two Additional Authorization Schemes Using PL/SQL and SQL"

• Defining Authorization Rule with SQL
  Use an Exists SQL Query authorization Scheme Type to define a rule based on a query.
• Using PL/SQL for an Authorization Rule
  Use a PL/SQL Function Returning Boolean scheme type to define a rule using custom logic.