DBA_APPLICATION_ROLES

DBA_APPLICATION_ROLES describes all the roles that have authorization policy functions defined.

USER_APPLICATION_ROLES describes all the roles for the current user that have authorization policy functions defined.

Column Datatype NULL Description
ROLE VARCHAR2(128) NOT NULL Name of the application role
SCHEMA VARCHAR2(128) NOT NULL Schema of the authorized package
PACKAGE VARCHAR2(128) NOT NULL Name of the authorized package

See Also: “USER_APPLICATION_ROLES”