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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
