Permissions Validation

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 ...

Get Alison Balter's Mastering Access 2002 Enterprise Development now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.