DBA_CONNECT_ROLE_GRANTEES view tips

Oracle Tips by Burleson Consulting

DBA_CONNECT_ROLE_GRANTEES

<< Return to the index

Oracle 11g makes the following comments about the DBA_CONNECT_ROLE_GRANTEES table: "Information regarding which users are granted CONNECT"

Column description of the DBA_CONNECT_ROLE_GRANTEES view:

GRANTEE

Description of DBA_CONNECT_ROLE_GRANTEES.GRANTEE: "User or schema to which CONNECT is granted"

PATH_OF_CONNECT_ROLE_GRANT

Description of DBA_CONNECT_ROLE_GRANTEES.PATH_OF_CONNECT_ROLE_GRANT: "The path of role inheritence through which the grantee is granted CONNECT"

ADMIN_OPT

Description of DBA_CONNECT_ROLE_GRANTEES.ADMIN_OPT: "If the grantee was granted the CONNECT role with Admin Option"

DBA_CONNECT_ROLE_GRANTEES View Source

Oracle 11g's data dictionary defines the DBA_CONNECT_ROLE_GRANTEES view using the following source query:

select grantee, connect_path, admin_option
from (select grantee,
'CONNECT'||SYS_CONNECT_BY_PATH(grantee, '/') connect_path,
granted_role, admin_option
from sys.dba_role_privs
where decode((select type# from user$ where name = upper(grantee)),
0, 'ROLE',
1, 'USER') = 'USER'
connect by nocycle granted_role = prior grantee
start with granted_role = upper('CONNECT'))

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.
You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books