ServerPermissionSetValue ServerPermissionSetValue ServerPermissionSetValue Enum

Definition

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

public enum class ServerPermissionSetValue
public enum ServerPermissionSetValue
Public Enum ServerPermissionSetValue
Inheritance
ServerPermissionSetValueServerPermissionSetValueServerPermissionSetValue

Fields

AdministerBulkOperations AdministerBulkOperations AdministerBulkOperations 0

The ability to administer bulk operations.

AlterAnyAvailabilityGroup AlterAnyAvailabilityGroup AlterAnyAvailabilityGroup 28

The ability to alter any available group.

AlterAnyConnection AlterAnyConnection AlterAnyConnection 2

The ability to alter any connection.

AlterAnyCredential AlterAnyCredential AlterAnyCredential 1

The ability to alter any credential.

AlterAnyDatabase AlterAnyDatabase AlterAnyDatabase 3

The ability to alter any database.

AlterAnyEndpoint AlterAnyEndpoint AlterAnyEndpoint 5

The ability to alter any endpoint.

AlterAnyEventNotification AlterAnyEventNotification AlterAnyEventNotification 4

The ability to alter any event notification.

AlterAnyEventSession AlterAnyEventSession AlterAnyEventSession 30

The ability to alter any event session.

AlterAnyLinkedServer AlterAnyLinkedServer AlterAnyLinkedServer 7

The ability to alter any linked server.

AlterAnyLogin AlterAnyLogin AlterAnyLogin 6

The ability to alter any login.

AlterAnyServerAudit AlterAnyServerAudit AlterAnyServerAudit 25

The ability to alter any server audit.

AlterAnyServerRole AlterAnyServerRole AlterAnyServerRole 26

The ability to alter any server role.

AlterResources AlterResources AlterResources 8

The ability to alter resources.

AlterServerState AlterServerState AlterServerState 9

The ability to alter the state of the server.

AlterSettings AlterSettings AlterSettings 10

The ability to alter settings.

AlterTrace AlterTrace AlterTrace 11

The ability to alter traces.

AuthenticateServer AuthenticateServer AuthenticateServer 12

The ability to authenticate the server.

ConnectAnyDatabase ConnectAnyDatabase ConnectAnyDatabase 32

The ability to connect to any database.

ConnectSql ConnectSql ConnectSql 14

The ability to connect to SQL Server.

ControlServer ControlServer ControlServer 13

The ability to control the server.

CreateAnyDatabase CreateAnyDatabase CreateAnyDatabase 15

The ability to create any database.

CreateAvailabilityGroup CreateAvailabilityGroup CreateAvailabilityGroup 29

The ability to create availability group.

CreateDdlEventNotification CreateDdlEventNotification CreateDdlEventNotification 16

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

CreateEndpoint CreateEndpoint CreateEndpoint 17

The ability to create endpoints.

CreateServerRole CreateServerRole CreateServerRole 27

The ability to create any server role.

CreateTraceEventNotification CreateTraceEventNotification CreateTraceEventNotification 18

The ability to create trace event notifications.

ExternalAccessAssembly ExternalAccessAssembly ExternalAccessAssembly 23

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 ImpersonateAnyLogin ImpersonateAnyLogin 33

The ability to impersonate any login.

SelectAllUserSecurables SelectAllUserSecurables SelectAllUserSecurables 31

The ability to select all user securables.

Shutdown Shutdown Shutdown 19

The ability to shut down the server.

UnsafeAssembly UnsafeAssembly UnsafeAssembly 24

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 ViewAnyDatabase ViewAnyDatabase 21

The ability to view any database.

ViewAnyDefinition ViewAnyDefinition ViewAnyDefinition 20

The ability to view any definition.

ViewServerState ViewServerState ViewServerState 22

The ability to view the state of the server.

Examples

Granting, Revoking, and Denying Permissions

Applies to