Export (0) Print
Expand All
0 out of 2 rated this helpful - Rate this topic

Syntax for Granting, Denying, and Revoking the SHOWPLAN Permission

The SHOWPLAN permission is a database-level permission. In general, the syntax for granting, denying, and revoking the SHOWPLAN permission is modeled after the other database level permissions. However, some of the GRANT, DENY, and REVOKE clauses that are available with other database-level permissions can not be used with the SHOWPLAN permission. The following sections provide the syntax for GRANTING, DENYING, and REVOKING the SHOWPLAN permission, and explain what clauses do not apply to SHOWPLAN. For more information about the general syntax for granting, denying, and revoking database-level permissions, see GRANT Database Permissions (Transact-SQL), DENY Database Permissions (Transact-SQL), and REVOKE Database Permissions (Transact-SQL).


To grant the SHOWPLAN permission
GRANT SHOWPLAN
TO <database_principal> [ , ...n ]

To deny the SHOWPLAN permission
DENY SHOWPLAN
TO <database_principal> [ , ...n ]

To revoke the SHOWPLAN permission
REVOKE SHOWPLAN
FROM <database_principal> [ , ...n ]

You cannot use the following clauses for granting the SHOWPLAN permission:

  • WITH GRANT OPTION

  • AS

You cannot use the following clauses for denying the SHOWPLAN permission:

  • CASCADE (because SHOWPLAN cannot be granted using the WITH GRANT OPTION clause)

  • AS

You cannot use the following clauses for revoking the SHOWPLAN permission:

  • GRANT OPTION FOR

  • CASCADE

  • AS

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.