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_Authentication

 

Where Authenticated?

Security_Center_Map_Logins_Users
Security_Center_Map_Contained_Users

 

Using Other Identities

Security_Center_Map_Credentials
Security_Center_Map_Exec_As_Login
Security_Center_Map_Exec_As_User
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder

Granting, Revoking, and Denying Permissions

Security_Center_Map_Securable_Classes
Security_Center_Map_Srv_Perms
Security_Center_Map_DB_Perms

 

Security by Roles

Security_Center_Map_Srv_Roles
Security_Center_Map_DB_Roles

 

Restricting Data Access to Selected Data Elements

Security_Center_Map_View_Procs
Security_Center_Map_Row_Level_Sec
Security_Center_Map_Data_Masking
Security_Center_Map_Signed_Objects
Security_Center_Map_BlankPlaceholder

Encrypting Files                           

Security_Center_Map_BitLocker
Security_Center_Map_NTFS_Encryp
Security_Center_Map_TDE
Security_Center_Map_Backup_Encryp

 

Encrypting Sources

Security_Center_Map_EKM
Security_Center_Map_Key_Vault
Security Center Map Always Encrypted

 

Column, Data & Key Encryption

Security_Center_Map_Cert
Security_Center_Map_Sym_Key
Security_Center_Map_Asym_Key
Security_Center_Map_Passphrase

Firewall Protection                        

Security_Center_Map_Windows_Firewall
Security_Center_Map_Service_Firewall
Security_Center_Map_DB_Firewall

 

Encrypting Data in Transit

Security_Center_Map_Forced_SSL
Security_Center_Map_Opt_SSL
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder

Automated Auditing                         

Security_Center_Map_SQL_Audit
Security_Center_Map_SQLDB_Audit

 

Custom Audit

Security_Center_Map_Triggers

 

Compliance

Security_Center_Map_Compliance
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder
Security_Center_Map_BlankPlaceholder
Security_Center_Map_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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft