Penn Computing

University of Pennsylvania
Penn Computing << go backback
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.

Primary Key Indexed Data Elements Related Tables
ROLE_NAME
ROLE_NAME
DW_ROLES_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

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania