DBA_CONNECT_ROLE_GRANTEES displays information about users who are granted the CONNECT privilege.
| Column | Datatype | NULL | Description |
| GRANTEE | VARCHAR2(30) | | User or schema to which the CONNECT role is granted |
| PATH_OF_CONNECT_ROLE_GRANT | VARCHAR2(4000) | | The path of role inheritance through which the grantee is granted the CONNECT role |
| ADMIN_OPT | VARCHAR2(3) | | Whether or not the grantee was granted the ADMIN option for the CONNECT role |
In Oracle 7: The CONNECT role was introduced with other predefined roles, i.e., DBA, RESOURCE, EXP_FULL_DATABASE, IMP_FULL_DATABASE.
In 8i: New roles are introduced which allow access to the dictionary views, i.e., SELECT_CATALOG_ROLE, EXECUTE_CATALOG_ROLE, DELETE_CATALOG_ROLE
In 9i: SELECT_CATALOG_ROLE works in conjunction with parameter O7_DICTIONARY_ACCESSIBILITY and SELECT ANY DICTIONARY privilege
In 10.2/11R1: the CONNECT role is changed, i.e., only having CREATE SESSION. The seven other privileges have been removed from the CONNECT role: CREATE TABLE, CREATE VIEW, CREATE SYNONYM, CREATE CLUSTER, CREATE DATABASE LINK, CREATE SEQUENCE, ALTER SESSION.
The DBA_CONNECT_ROLE_GRANTEES view enables administrators who decide to continue using the old CONNECT role to list which users have the CONNECT role.
No comments:
Post a Comment