DAC-Secured Tables, Views And Columns: Security Metadata Administration Tool (SMAT) Settings
DAC-Secured Tables, Views And Columns
Security Metadata Administration Tool (SMAT) Settings
/Admin/Access and Security
More Information URL:
Enterprise Data and Analytics
This report shows the current security settings for each table that has had the Data Management Committee's Roles And Access Matrix security settings applied (also known as each DAC-enabled table). This report displays the security Roles as column headings and the columns within the selected table as rows in this display. A red N directly below the Role name indicates that role does not have access to the entire table. A red Y in the Restricted Column column indicates that column is considered sensitive per the Roles And Access Matrix. A red N inside the matrix indicates the Role does not have access to that column within the table.
Report data is selected from a view within EDWDataDictionary, that is an amalgamation of all DAC-enabled tables/databases from all instances of the DAC on all EDW servers