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)
Syntax
'Declaration
Public Enumeration ServerPermissionSetValue
'Usage
Dim instance As ServerPermissionSetValue
public enum ServerPermissionSetValue
public enum class ServerPermissionSetValue
type ServerPermissionSetValue
public enum ServerPermissionSetValue
Members
| Member name | Description | |
|---|---|---|
| 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. | |
| 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. | |
| 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. |
Examples
Granting, Revoking, and Denying Permissions