Enumeração ServerPermissionSetValue

The ServerPermissionSetValue enumeration is a list of constant values that specify all the database permissions.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SqlEnum (em Microsoft.SqlServer.SqlEnum.dll)

Sintaxe

'Declaração
Public Enumeration ServerPermissionSetValue
'Uso
Dim instance As ServerPermissionSetValue

public enum ServerPermissionSetValue

public enum class ServerPermissionSetValue

type ServerPermissionSetValue

public enum ServerPermissionSetValue

Membros

	Nome do membro	Descrição
	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.

Exemplos

Concedendo, revogando e negando permissões

Consulte também

Referência

Namespace Microsoft.SqlServer.Management.Smo