DatabasePermissionSet.Showplan Property
Gets or sets the Boolean property value that specifies whether to include the SHOWPLAN permission in the permission set. This permission lets the grantee view the execution plan for stored procedures in the database.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Property Showplan As Boolean
Get
Set
'Usage
Dim instance As DatabasePermissionSet
Dim value As Boolean
value = instance.Showplan
instance.Showplan = value
public bool Showplan { get; set; }
public:
property bool Showplan {
bool get ();
void set (bool value);
}
member Showplan : bool with get, set
function get Showplan () : boolean
function set Showplan (value : boolean)
Property Value
Type: System.Boolean
A Boolean value that specifies whether to include the SHOWPLAN permission in the permission set.If True, the permission is included in the permission set.If False (default), the permission is excluded from the permission set.
Examples
Granting, Revoking, and Denying Permissions
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace