ServerPermissionSetValue Enumeration

 

The ServerPermissionSetValue enumeration is a list of constant values that specify all the database permissions.

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

public enum ServerPermissionSetValue

Member nameDescription
AdministerBulkOperations

The ability to administer bulk operations.

AlterAnyAvailabilityGroup

The ability to alter any available group.

AlterAnyConnection

The ability to alter any connection.

AlterAnyCredential

The ability to alter any credential.

AlterAnyDatabase

The ability to alter any database.

AlterAnyEndpoint

The ability to alter any endpoint.

AlterAnyEventNotification

The ability to alter any event notification.

AlterAnyEventSession

The ability to alter any event session.

AlterAnyLinkedServer

The ability to alter any linked server.

AlterAnyLogin

The ability to alter any login.

AlterAnyServerAudit

The ability to alter any server audit.

AlterAnyServerRole

The ability to alter any server role.

AlterResources

The ability to alter resources.

AlterServerState

The ability to alter the state of the server.

AlterSettings

The ability to alter settings.

AlterTrace

The ability to alter traces.

AuthenticateServer

The ability to authenticate the server.

ConnectAnyDatabase

The ability to connect to any database.

ConnectSql

The ability to connect to SQL Server.

ControlServer

The ability to control the server.

CreateAnyDatabase

The ability to create any database.

CreateAvailabilityGroup

The ability to create availability group.

CreateDdlEventNotification

The ability to create data definition language (DDL) event notifications.

CreateEndpoint

The ability to create endpoints.

CreateServerRole

The ability to create any server role.

CreateTraceEventNotification

The ability to create trace event notifications.

ExternalAccessAssembly

Gets or sets the Boolean property value that specifies whether to include the EXTERNAL ACCESS (XA) permission in the permission set. This permission lets the grantee access external system resources such as assembly files, networks, environmental variables, and the registry.

ImpersonateAnyLogin

The ability to impersonate any login.

SelectAllUserSecurables

The ability to select all user securables.

Shutdown

The ability to shut down the server.

UnsafeAssembly

Gets or sets the Boolean property value that specifies whether to include the UNSAFE permission in the permission set. This permission allows the grantee unrestricted access to resources, both within and outside SQL Server, including calls to unmanaged code

ViewAnyDatabase

The ability to view any database.

ViewAnyDefinition

The ability to view any definition.

ViewServerState

The ability to view the state of the server.

Return to top
Show: