Reference table contains records associating Data Warehouse roles which are indirectly granted by virtue of direct grants of their parent roles.
Understanding what access may have been indirectly granted to a user.
||Indexed Data Elements
- 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.
Questions about this page? Email us at email@example.com
|Information Systems and Computing|
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania