Process to Automate Access for Systems

System or Application access requests require that additional information is supplied on the intent and usage patterns expected in order to determine if any special access and handling will be required. Queries to extract Enterprise Data Warehouse (EDW) data to be stored in local or departmental repositories must be documented and approved by appropriate Data Stewardship and coordinated with central UW-IT staff, as outlined by UW Data Policies.

Instructions and Process

1. Acquire application NetID that meets the standards by following the steps found in DMC Guideline 1017.
2. Determine the appropriate role to request by reviewing the Security Access and Roles Matrix to identify the role with the level of access you believe is needed in order to fulfill your application data needs.  Please review the role definitions and column data privileges to select the appropriate role.
3. Fill out the form below with the requested information, including the Access Role being requested, and then click Submit.
4. When the form is submitted a copy will be emailed to your supervisor with instructions to reply, acknowledging endorsement of your access request.
5. Once supervisor endorsement is received, your request will be submitted for Data Stewardship review and endorsement. Data Stewardship validates business need and appropriate access request levels. Please note that this process usually takes a few days, but may take longer.
6. Once Data Stewardship endorsement is received, your request will be submitted to appropriate central UW-IT staff to review and endorse, usually within three working days. UW-IT staff review for validation of expected security, usage and performance assumptions. UW-IT may provide an appropriate time window in which the query can be scheduled to run. NOTE: Queries needing to be run on-demand should be coordinated with UW-IT in advance by contacting help@uw.edu.
7. Once UW-IT staff endorsement is received, you will be contacted by dmc-support@uw.edu when your access has been activated. You will then be able to query the data.