You are currently viewing the legacy RunMyJobs documentation site. This site will be taken down later this month.
All current and future RunMyJobs documentation, including versions 2023.3 and later, can be found here.
Please update your bookmarks. Use the version dropdown menu to select the documentation you need.

← rs_dba_job_parametersrs_dba_scripts →

on-site-related topic 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

← rs_dba_job_parametersrs_dba_scripts →