ServerPermissionSetValue Enumeration
Collapse the table of content
Expand the table of content

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
AdministerBulkOperationsThe ability to administer bulk operations.
AlterAnyServerAuditThe ability to alter any server audit.
AlterAnyCredentialThe ability to alter any credential.
AlterAnyConnectionThe ability to alter any connection.
AlterAnyDatabaseThe ability to alter any database.
AlterAnyEventNotificationThe ability to alter any event notification.
AlterAnyEndpointThe ability to alter any endpoint.
AlterAnyLoginThe ability to alter any login.
AlterAnyLinkedServerThe ability to alter any linked server.
AlterResourcesThe ability to alter resources.
AlterServerStateThe ability to alter the state of the server.
AlterSettingsThe ability to alter settings.
AlterTraceThe ability to alter traces.
AuthenticateServerThe ability to authenticate the server.
ControlServerThe ability to control the server.
ConnectSqlThe ability to connect to SQL Server.
CreateAnyDatabaseThe ability to create any database.
CreateDdlEventNotificationThe ability to create data definition language (DDL) event notifications.
CreateEndpointThe ability to create endpoints.
CreateTraceEventNotificationThe ability to create trace event notifications.
ShutdownThe ability to shut down the server.
ViewAnyDefinitionThe ability to view any definition.
ViewAnyDatabaseThe ability to view any database.
ViewServerStateThe ability to view the state of the server.
ExternalAccessAssemblyGets 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.
UnsafeAssemblyGets 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

Community Additions

© 2016 Microsoft