Statement Permissions

Statement permissions are not object-specific. They can be granted only by the SA or the database owner. Statement permissions apply to these statements:

• CREATE DATABASE (can be granted only by the SA and only to users in the master database)
• CREATE DEFAULT
• CREATE PROCEDURE
• CREATE RULE
• CREATE TABLE
• CREATE VIEW
• DUMP DATABASE
• DUMP TRANSACTION

Each database has its own independent permissions system. In other words, being granted permission to use a certain statement in one database has no effect in other databases.

If you try to use a statement or database object for which you do not have permission, SQL Server returns an error message.

To grant or revoke statement permissions, use SQL Enterprise Manager or the GRANT and REVOKE statements. For information about managing permissions with SQL Enterprise Manager, see Chapter 9, Managing Security. For information about the GRANT and REVOKE statements, see the Microsoft SQL Server Transact-SQL Reference.