DW_ROLES_INDIRECT Table - Data Element Index   Tables and Data Elements   Infrastructure Home   Data Warehouse Home

DW_ROLES_INDIRECT Table

Explanation
Reference table contains records associating Data Warehouse roles which are indirectly granted by virtue of direct grants of their parent roles.

Common Uses
Understanding what access may have been indirectly granted to a user.

PARENT_ROLE

CHILD_ROLE

DW_ROLES_MV (DWADMIN)
DW_ROLES_DESC (DWADMIN)

Cautions

• Not all roles have related parents. Only those roles that are indirectly granted by virtue of grants to another role appear in this table.


• This table contains descriptions of database roles which may be granted to users of the Data Warehouse. Database roles map roughly to Warehouse data collections. Please refer to the DW_ROLES table to determine which roles have actually been granted to users.

• The DW_ROLES_INDIRECT table is stored in the DWADMIN schema in the Data Warehouse.

DW_ROLES_INDIRECT Table - Data Element Index   Tables and Data Elements   Infrastructure Home   Data Warehouse Home