ServerPermissionSet.AlterSettings Property

Gets or sets the Boolean property value that specifies whether to include the ALTER SETTINGS (ASLT) permission in the permission set. This permission lets the grantee alter any settings on the instance of SQL Server, such as the default database directory.

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

Syntax

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

value = instance.AlterSettings

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

Property Value

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