Microsoft SQL Server uses permissions to enforce database security. The SQL Server permissions system specifies which users are authorized to use which Transact-SQL statements, views, and stored procedures. The ability to assign permissions is determined by each user's status (as SA, database owner, or database object owner). Permissions are set on database users or groups, not on login IDs.
The topics that follow provide an orientation to SQL Server permissions. To learn about the tools you will use and the procedures you will perform to manage permissions, see Chapter 9, Managing Security.
For more information about permissions, choose one of the following topics:
Object and Statement Permissions
Permissions on Views and Stored Procedures