Defining Authorization Rule with SQL

Use an Exists SQL Query authorization Scheme Type to define a rule based on a query.

As shown below, the Manages Others rule uses the following query that retrieves a row if at least one employee has the current user’s EMPNO as its MGR value:

select 1
  from eba_demo_emp
 where mgr = (select empno
                from eba_demo_emp
               where ename = :APP_USER)
fetch first row only

Using SQL to Define Authorization Scheme Rule for Managers

Description of the illustration manage-others-authz-scheme.png