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
public bool Showplan { get; set; }
public:
property bool Showplan {
bool get ();
void set (bool value);
}
/** @property */
public boolean get_Showplan ()
/** @property */
public void set_Showplan (boolean value)
public function get Showplan () : boolean
public function set Showplan (value : boolean)
Property Value
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.
Remarks
Updated text:
This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.
Example
How to: Grant Server Permissions in Visual Basic .NET
Thread Safety
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
See Also
Reference
DatabasePermissionSet Class
DatabasePermissionSet Members
Microsoft.SqlServer.Management.Smo Namespace
Other Resources
Granting, Revoking, and Denying Permissions
Permissions
Change History
Release |
History |
Changed content:
|