Export (0) Print
Expand All
Expand Minimize

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.
AlterAnyAvailabilityGroupThe ability to alter any available group.
AlterAnyConnectionThe ability to alter any connection.
AlterAnyCredentialThe ability to alter any credential.
AlterAnyDatabaseThe ability to alter any database.
AlterAnyEndpointThe ability to alter any endpoint.
AlterAnyEventNotificationThe ability to alter any event notification.
AlterAnyEventSessionThe ability to alter any event session.
AlterAnyLinkedServerThe ability to alter any linked server.
AlterAnyLoginThe ability to alter any login.
AlterAnyServerAuditThe ability to alter any server audit.
AlterAnyServerRoleThe ability to alter any server role.
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.
ConnectAnyDatabaseThe ability to connect to any database.
ConnectSqlThe ability to connect to SQL Server.
ControlServerThe ability to control the server.
CreateAnyDatabaseThe ability to create any database.
CreateAvailabilityGroupThe ability to create availability group.
CreateDdlEventNotificationThe ability to create data definition language (DDL) event notifications.
CreateEndpointThe ability to create endpoints.
CreateServerRoleThe ability to create any server role.
CreateTraceEventNotificationThe ability to create trace event notifications.
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.
ImpersonateAnyLoginThe ability to impersonate any login.
SelectAllUserSecurablesThe ability to select all user securables.
ShutdownThe ability to shut down the server.
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
ViewAnyDatabaseThe ability to view any database.
ViewAnyDefinitionThe ability to view any definition.
ViewServerStateThe ability to view the state of the server.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft