Share via

  • Article

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.