The Enterprise Data Warehouse (EDW) is the central repository of the University of Washington’s electronically stored institutional data. Our warehouse is designed to facilitate reporting and analysis, so that decisions-makers can have better information on which to act.
The EDW houses a large volume of data from across multiple subject areas. In order to protect sensitive data while providing uniform access to enterprise information, the Data Management Committee developed security roles for access to the EDW. Users are assigned to these roles according to their job responsibilities. Principles identified in the UW Information Systems Security Policy Statement informed the creation of these roles.
These security roles provide fine-grained access to information and define privileges based on specific row and column access needs. The Security Access and Roles Matrix (Matrix) describes the roles and their privilege levels across data subject areas (such as Academic, HR, Finance).
University faculty and staff must request access to EDW data as well as reporting and analysis tools. Depending on the type of data needed, access is granted by a local ASTRA administrator or by the Data Custodians. In both cases, users are assigned to one or more roles defined by the Matrix.