Export (0) Print
Expand All

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 Engine and Azure 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

Security Center Map Triggers
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

Creating DDL Triggers and DML Triggers

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2015 Microsoft