Security Features in MS SQL

Intermediate Updated March 20, 2025

🔐 Security Features in MS SQL

Security is multi-layered in SQL Server:

  • Authentication: Supports Windows and SQL Server logins
  • Authorization: Role-based access control
  • Encryption: Transparent Data Encryption (TDE), Always Encrypted
  • Auditing: SQL Server Audit logs user actions
-- Grant SELECT permission
GRANT SELECT ON Books TO ReaderRole;