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.
AlterAnyServerAudit
AlterAnyCredential The ability to alter any credential.
AlterAnyConnection The ability to alter any connection.
AlterAnyDatabase The ability to alter any database.
AlterAnyEventNotification The ability to alter any event notification.
AlterAnyEndpoint The ability to alter any endpoint.
AlterAnyLogin The ability to alter any login.
AlterAnyLinkedServer The ability to alter any linked server.
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.
ControlServer The ability to control the server.
ConnectSql The ability to connect to SQL Server.
CreateAnyDatabase The ability to create any database.
CreateDdlEventNotification The ability to create data definition language (DDL) event notifications.
CreateEndpoint The ability to create endpoints.
CreateTraceEventNotification The ability to create trace event notifications.
Shutdown The ability to shut down the server.
ViewAnyDefinition The ability to view any definition.
ViewAnyDatabase The ability to view any database.
ViewServerState The ability to view the state of the server.
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.
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