DBA_APPLICATION_ROLES describes all the roles that have authentication policy functions defined.
| Column | Datatype | NULL | Description | 
|---|---|---|---|
| ROLE | VARCHAR2(30) | NOT NULL | Name of the application role | 
| SCHEMA | VARCHAR2(30) | NOT NULL | Schema of the authorized package | 
| PACKAGE | VARCHAR2(30) | NOT NULL | Name of the authorized package |