5.217 DBA_CHECKED_ROLES_PATH

DBA_CHECKED_ROLES_PATH lists the roles that are used for the role analysis policies reported by the DBMS_PRIVILEGE_CAPTURE.GENERATE_RESULT procedure.

This view provides access to analyzed role records in SYS tables.

You must have the CAPTURE_ADMIN role to access this view.

Column	Datatype	NULL	Description
CAPTURE	VARCHAR2(128)	NOT NULL	Name of a role analysis policy
SEQUENCE	NUMBER	NOT NULL	The sequence number of the role analysis run during which the role was reported
OS_USER	VARCHAR2(128)		Operating system login username
USERHOST	VARCHAR2(128)		Client host machine name
MODULE	VARCHAR2(64)		Module name
USERNAME	VARCHAR2(128)	NOT NULL	Name of the user whose role was reported
CHECKED_ROLE	VARCHAR2(128)		Checked role
PATH	GRANT_PATH		Role grant paths
RUN_NAME	VARCHAR2(128)		The name of the run during which the role was reported

See Also:

"DBA_CHECKED_ROLES"