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

DW_ROLES_DESC Table

Explanation
Reference table providing descriptions for data roles granted to users of the Data Warehouse.

Common Uses
Displaying the friendlier description of a database role, rather than the system role name.

ROLE_NAME

ROLE_NAME

DW_ROLES_MV (DWADMIN)
DW_ROLES_INDIRECT_MV (DWADMIN)    

Cautions

• 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_DESC table is stored in the DWADMIN schema in the Data Warehouse.

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