When a user logs in to the server, SQL Server first authenticates him to ensure that he is a valid user. SQL Server then grants the user permission to perform any task assigned to the user or to any roles that the user is a member of.
Types of Permissions
SQL Server offers three types of permissions. They include:
Object permissions— Permissions set for objects such as tables and views. These include SELECT, INSERT, UPDATE, and DELETE permissions.
Statement permissions— Permissions applied to statements such as the CREATE VIEW statement. These permissions define what rights the user has to the specified statement.
Inherited or implied permissions— These permissions refer to rights that a user has to an object because he ...