Share via


Security Center for SQL Server Database Engine and Azure SQL Database

This page provides links to help you locate the information that you need about security and protection in the SQL Server Database Engineand Azure SQL Database.

Note

The capabilities of Azure SQL Database continue to improve. See the most recent version of this topic for the most recent information about SQL Database.

Authentication: Who are you? Authorization: What can you do? Encryption: Storing Secret Data Connection Security: Restricting and Securing Auditing: Recording Access
Who Authenticates?

Security Center Map Windows Authentication



Security Center Map SQL Server Authentication

Where Authenticated?

Security Center Map Logins and Users



Security Center Map Contained Database Users

Using Other Identities

Security Center Map Credentials

Security Center Map Execute As Login

Security Center Map Execute As User

Placeholder

Placeholder

Placeholder

Placeholder
Granting, Revoking, and Denying Permissions

Security Center Map Securable Classes

Security Center Map Server Permissions

Security Center Map Database Permissions

Security by Roles

Security Center Map Server Roles

Security Center Map Database Roles

Restricting Data Access to Selected Data Elements

Security Center Map Views and Procedures

Security Center Map Row Level Security

Security Center Map Dynamic Data Masking

Security Center Map Signed Objects

Placeholder
Encrypting Files

Security Center Map BitLocker

Security Center Map NTFS Encryption

Security Center Map TDE

Security Center Map Backup Encryption

Encrypting Sources

Security Center Map EKM

Security Center Map Azure Key Vault

Column, Data & Key Encryption

Security Center Map Encrypt by Certificate

Security Center Map Encrypt by Symmetric Key

Security Center Map Encrypt by Asymmetric Key

Security Center Map Encrypt by Passphrase
Firewall Protection

Security Center Map Windows Firewall

Security Center Map Service Firewall

Security Center Map Database Firewall

Encrypting Data in Transit

Security Center Map Forced SSL

Security Center Map Optional SSL

Placeholder

Placeholder

Placeholder

Placeholder

Placeholder

Placeholder

Placeholder
Automated Auditing

Security Center Map SQL Server Audit

Security Center Map SQL Database Audit

Custom Audit

Placeholder

Security Center Map Triggers

Compliance

SecCtrCompliance

Placeholder

Placeholder

Placeholder

Placeholder

Placeholder

Security Center Legend

Small File Folder Icon Authentication: Who are you?
Who Authenticates? (Windows or SQL Server)

Authenticate at the master database (Logins and database users)

Authenticate at a user database

Using Other Identities

Small File Folder Icon Encryption: Storing Secret Data
Encrypting Files

Encrypting Sources

Column, Data and Key Encryption

Small File Folder Icon Authorization: What can you do?
Granting, Revoking, and Denying Permissions

Security by Roles

Restricting Data Access to Selected Data Elements

Small File Folder Icon Connection Security: Restricting and Securing
Firewall Protection

Encrypting Data in Transit

Small File Folder Icon Auditing: Recording Access
Automated Auditing

Custom Audit Implementation

Small File Folder Icon Compliance
SQL Server

SQL Database

See Also

Securing SQL Server
Principals (Database Engine)
SQL Server Certificates and Asymmetric Keys
SQL Server Encryption
Surface Area Configuration
Strong Passwords
TRUSTWORTHY Database Property
Database Engine Features and Tasks