Access Management for Microsoft SQL Server
This document provides an overview of access management features supported by Privacera for Microsoft SQL Server.
Access Management
| Topic | Detail |
| Integration methodology | Privacera PolicySync |
| Access Tools | JDBC |
| Supported User Identities | SQL Users (Internal and External/Azure AD), SQL Server Database Roles, Privacera Users/Groups/Roles |
| Resource Policy Service Type | privacera_mssql |
Supported Access Management Features
| Feature | Supported | Native | Using SecureView |
Database Access Control | Yes | Yes | No |
Schema Access Control | Yes | Yes | No |
Table Access Control | Yes | Yes | Yes |
View Access Control | Yes | Yes | Yes |
Column Access Control | Yes | Yes | Yes |
Row Access Control | Yes | Yes | Yes |
Column Data Masking | Yes | No | Yes |
Column Data Encryption | No | No | N/A |
Centralized Access Audit | Yes | N/A | N/A |
Granular Access Audit Record | No | N/A | N/A |