SQL Server has many features which help in ensuring the security of the data and data integrity. It has many features added up from SQL Server 2008 to enhance security levels. In first exercise, we will learn to manage logins and users. In second exercise we will learn about object level security and in third exercise, we will learn about encryption and proxies.
Exercise 1: Managing Logins & Users
Exercise 2: Object-level Security
Exercise 3: Encryption and Proxies