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