Udostępnij przez


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

'Deklaracja
Public Enumeration ServerPermissionSetValue
public enum ServerPermissionSetValue
public enum class ServerPermissionSetValue
public enum ServerPermissionSetValue
public enum ServerPermissionSetValue

Members

Member name Description
AdministerBulkOperations The ability to administer bulk operations.
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.
AlterAnyLinkedServer The ability to alter any linked server.
AlterAnyLogin The ability to alter any login.
AlterAnyServerAudit  
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.
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.
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.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.