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
Granting, Revoking, and Denying Permissions