DBA_APPLICATION_ROLES

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