Share via


ServerPermissionSet.AlterAnyDatabase Property

Gets or sets the Boolean property value that specifies whether to include the ALTER ANY DATABASE (ALDB) permission in the permission set. This permission lets the grantee create, alter, or drop any database on the instance of SQL Server.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Property AlterAnyDatabase As Boolean 
    Get 
    Set
'Usage
Dim instance As ServerPermissionSet 
Dim value As Boolean 

value = instance.AlterAnyDatabase

instance.AlterAnyDatabase = value
public bool AlterAnyDatabase { get; set; }
public:
property bool AlterAnyDatabase {
    bool get ();
    void set (bool value);
}
member AlterAnyDatabase : bool with get, set
function get AlterAnyDatabase () : boolean 
function set AlterAnyDatabase (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies whether to include the ALTER ANY DATABASE (ALDB) 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

ServerPermissionSet Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Permissions (Database Engine)

sys.server_permissions (Transact-SQL)

CREATE DATABASE (Transact-SQL)