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 |
Supported Matrix
| Component | Version/Details |
| Azure SQL Database | Supported |
| Azure Synapse Analytics | Supported |
| SQL Server (On-Premises) | 2019 |