共用方式為


DatabasePermissionSet.Showplan 屬性

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.

命名空間:  Microsoft.SqlServer.Management.Smo
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public Property Showplan As Boolean 
    Get 
    Set
'用途
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)

屬性值

型別: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.

範例

授與、撤銷和拒絕權限

請參閱

參考

DatabasePermissionSet 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

權限 (Database Engine)