rs_dba_role_privs

The following table lists the columns for the rs_dba_role_privs view. The equivalent jcs_dba_role_privs view is available for backward compatibility reasons. The difference between the two is the data type of the date/time columns; the rs_* views use TIMESTAMP WITH TIME ZONE while the jcs_* views use DATE.

Column	Datatype	Description
GRANTEE	VARCHAR2	Name of the user or role receiving the grant
GRANTED_ROLE	VARCHAR2	Name of the granted role
ADMIN_OPTION	VARCHAR2	Grant was with the ADMIN option
DEFAULT_ROLE	VARCHAR2	Role is designated as a DEFAULT ROLE for the user

note

: Cronacle uses an external authentication system where roles are granted to users. This is synchronized as soon a user logs in. It is therefore possible that the contents of this view is not up to date.

note

ADMIN_OPTION: It is not possible to grant roles from within Cronacle. This is now done in an external authentication system.

note

DEFAULT_ROLE: It is not possible to enable or disable roles within Cronacle.

plsqlTopic

onsiteTopic