SQL Server Security

1.Logins & Server Roles

• Logins and Server Roles define users and permissions at the Instance level.
• Server Role permissions cannot be seen through the user interface, to do this you need to execute:

sp_srvrolepermission

• If you want to grant or deny a specific permission on a database to a user you can use the following command:

USE [database]
GO
DENY ALTER TO [domain\user]
GO

NOTE: Deleting the Logins won’t delete the Users at the database level. This will result in orphaned Users.