SQL Database Controls - 071-0571-19

Description of Agency

The Department of Technology, Management, and Budget (DTMB) uses SQL database software to manage the data for approximately 450 of the State’s IT systems. Teams of database administrators within DTMB Agency Services manage the SQL databases. The databases are used for transation processing and reporting of critical IT systems including the Michigan Women, Infants, and Children Information System (MI-WIC); Newborn Screening (NBS); and Enterprise Backup and Recovery System (EBUR). Security and access controls are the responsibility of the database administrators in conjunction with the data owners at the various State agencies.

Audit Objectives

  1. To assess the effectiveness of DTMB’s governance structure over the State’s SQL database environment.

  2. To assess the effectiveness of DTMB’s efforts to implement key security and access controls over the State’s SQL databases.


Timing

Estimated Release Date: Early 2020


← Back to all work in progress