Partilhar via

Classe ServerPermissionSet

  • Artigo

The ServerPermissionSet object represents a set of server permissions.

Hierarquia de herança

System.Object
  Microsoft.SqlServer.Management.Smo.PermissionSetBase
    Microsoft.SqlServer.Management.Smo.ServerPermissionSet

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

Sintaxe

'Declaração
Public NotInheritable Class ServerPermissionSet _
    Inherits PermissionSetBase
'Uso
Dim instance As ServerPermissionSet

public sealed class ServerPermissionSet : PermissionSetBase

public ref class ServerPermissionSet sealed : public PermissionSetBase

[<SealedAttribute>]
type ServerPermissionSet =  
    class 
        inherit PermissionSetBase 
    end

public final class ServerPermissionSet extends PermissionSetBase

O tipo ServerPermissionSet expõe os membros a seguir.

Construtores

  Nome Descrição
Método público ServerPermissionSet() Initializes a new instance of the ServerPermissionSet class.
Método público ServerPermissionSet(ServerPermission) Initializes a new instance of the ServerPermissionSet class based on the specified permission.
Método público ServerPermissionSet(array<ServerPermission[]) Initializes a new instance of the ServerPermissionSet class based on the specified set of permissions.
Método público ServerPermissionSet(ServerPermissionSet) Initializes a new instance of the ServerPermissionSet class based on the specified set of permissions.

Início

Propriedades

  Nome Descrição
Propriedade pública AdministerBulkOperations Gets or sets the Boolean property value that specifies whether to include the ADMINISTER BULK OPERATIONS (ADBO) permission in the permission set. This permission lets the grantee perform bulk insert operations on the instance of SQL Server, such as importing data by using the bcp command, using the BULK INSERT statement, or using the INSERT…SELECT * FROM OPENROWSET(BULK…) statement.
Propriedade pública AlterAnyAvailabilityGroup Gets or sets the Boolean property value that specifies whether to include the ALTER ANY AVAILABILITY GROUP permission in the permission set. This permission lets the grantee create, alter, or drop any availability group on the instance of SQL Server.
Propriedade pública AlterAnyConnection Gets or sets the Boolean property value that specifies whether to include the ALTER ANY CONNECTION (ALCO) permission in the permission set. This permission lets the grantee create, alter, or drop any connection on the instance of SQL Server.
Propriedade pública AlterAnyCredential Gets or sets the Boolean property value that specifies whether to include the ALTER ANY CREDENTIAL (ALCD) permission in the permission set. This permission lets the grantee create, alter, or drop any credential on the instance of SQL Server.
Propriedade pública AlterAnyDatabase Gets or sets the Boolean property value that specifies whether to include the ALTER ANY DATABASE (ALDB) permission in the permission set. This permission lets the grantee create, alter, or drop any database on the instance of SQL Server.
Propriedade pública AlterAnyEndpoint Gets or sets the Boolean property value that specifies whether to include the ALTER ANY ENDPOINT (ALHE) permission in the permission set. This permission lets the grantee create, alter, or drop any endpoint on the instance of SQL Server.
Propriedade pública AlterAnyEventNotification Gets or sets the Boolean property value that specifies whether to include the ALTER ANY EVENT NOTIFICATION (ALES) permission in the permission set. This permission lets the grantee to create, alter, or drop any event notification on the instance of SQL Server.
Propriedade pública AlterAnyEventSession Gets or sets the Boolean property value that specifies whether to include the ALTER ANY EVENT SESSION permission in the permission set. This permission lets the grantee create, alter, or drop any event session on the instance of SQL Server.
Propriedade pública AlterAnyLinkedServer Gets or sets the Boolean property value that specifies whether to include the ALTER ANY LINKED SERVER (ALLS) permission in the permission set. This permission lets the grantee create, alter, or drop any linked server on the instance of SQL Server.
Propriedade pública AlterAnyLogin Gets or sets the Boolean property value that specifies whether to include the ALTER ANY LOGIN (ALLG) permission in the permission set. This permission lets the grantee create, alter, or drop any login on the instance of SQL Server.
Propriedade pública AlterAnyServerAudit Gets or sets the Boolean property value that specifies whether to include the ALTER ANY SERVER AUDIT permission in the permission set. This permission lets the grantee stop, start, or pause the instance of SQL Server.
Propriedade pública AlterAnyServerRole Gets or sets the Boolean property value that specifies whether to include the ALTER ANY SERVER ROLE permission in the permission set. This permission lets the grantee stop, start, or pause the instance of SQL Server.
Propriedade pública AlterResources Gets or sets the Boolean property value that specifies whether to include the ALTER RESOURCES (ALRS) permission in the permission set. This permission lets the grantee create, alter, or drop any resource on the instance of SQL Server.
Propriedade pública AlterServerState Gets or sets the Boolean property value that specifies whether to include the ALTER SERVER STATE (ALSS) permission in the permission set. This permission lets the grantee stop, start, or pause the instance of SQL Server.
Propriedade pública AlterSettings Gets or sets the Boolean property value that specifies whether to include the ALTER SETTINGS (ASLT) permission in the permission set. This permission lets the grantee alter any settings on the instance of SQL Server, such as the default database directory.
Propriedade pública AlterTrace Gets or sets the Boolean property value that specifies whether to include the ALTER TRACE (ALTR) permission in the permission set. This permission lets the grantee start, or stop trace runs or modify the trace options on the instance of SQL Server.
Propriedade pública AuthenticateServer Gets or sets the Boolean property value that specifies whether to include the AUTHENTICATE SERVER permission in the permission set. This permission lets the grantee authenticate with the instance of SQL Server.
Propriedade pública ConnectSql Gets or sets the Boolean property value that specifies whether to include the CONNECT SQL (COSQ) permission in the permission set. This permission lets the grantee connect to the instance of SQL Server.
Propriedade pública ControlServer Gets or sets the Boolean property value that specifies whether to include the CONTROL SERVER (CL) permission in the permission set. This permission lets the grantee grant any permission on any securable on the instance of SQL Server.
Propriedade pública CreateAnyDatabase Gets or sets the Boolean property value that specifies whether to include the CREATE ANY DATABASE (CRDB) permission in the permission set. This permission lets the grantee create, alter, or drop any database on the instance of SQL Server.
Propriedade pública CreateAvailabilityGroup Gets or sets the Boolean property value that specifies whether to include the CREATE AVAILABILITY GROUP permission in the permission set. This permission lets the grantee create, alter, or drop availability group on the instance of SQL Server.
Propriedade pública CreateDdlEventNotification Gets or sets the Boolean property value that specifies whether to include the CREATE DDL EVENT NOTIFICATION (CRDE) permission in the permission set. This permission lets the grantee create any DDL (Data Definition Language) event notification on the instance of SQL Server, such as the event that is raised when a database is created.
Propriedade pública CreateEndpoint Gets or sets the Boolean property value that specifies whether to include the CREATE ENDPOINT (CRHE) permission in the permission set. This permission lets the grantee create endpoints on the instance of SQL Server for SOAP, Transact-SQL, database mirroring, and Service Broker.
Propriedade pública CreateServerRole Gets or sets the Boolean property value that specifies whether to include the CREATE SERVER ROLE permission in the permission set. This permission lets the grantee create server role on the instance of SQL Server.
Propriedade pública CreateTraceEventNotification Gets or sets the Boolean property value that specifies whether to include the CREATE TRACE EVENT NOTIFICATION (CRTE) permission in the permission set. This permission lets the grantee create trace event notifications on the instance of SQL Server.
Propriedade pública 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.
Propriedade pública Shutdown Gets or sets the Boolean property value that specifies whether to include the SHUTDOWN (SHDN) permission in the permission set. This permission lets the grantee stop the SQL Server service.
Propriedade pública 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
Propriedade pública ViewAnyDatabase Gets or sets the Boolean property value that specifies whether to include the VIEW ANY DATABASE (VWDB) permission in the permission set. This permission lets the grantee view the definition (metadata) of any database on the instance of SQL Server.
Propriedade pública ViewAnyDefinition Gets or sets the Boolean property value that specifies whether to include the VIEW ANY DEFINITION (VWAD) permission in the permission set. This permission lets the grantee view the definition of any server that is securable on the instance of SQL Server.
Propriedade pública ViewServerState Gets or sets the Boolean property value that specifies whether to include the VIEW SERVER STATE (VWSS) permission in the permission set. This permission lets the grantee view the state of the instance of SQL Server.

Início

Métodos

  Nome Descrição
Método público Add(ServerPermission) Returns a server permission set after adding a new server permission to the referenced permission set.
Método públicoMembro estático Add(ServerPermissionSet, ServerPermission) Returns a server permission set after adding a new server permission to the specified permission set.
Método público Equals Determines whether the referenced server permission object is equal to a specified object. (Substitui PermissionSetBase.Equals(Object).)
Método público GetHashCode Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Substitui PermissionSetBase.GetHashCode().)
Método público GetType (Herdado de Object.)
Método público Remove Removes a permission from the permission set.
Método públicoMembro estático Subtract Returns a server permission set after subtracting a server permission from the specified permission set.
Método público ToString Returns the string value that represents the specified PermissionSetBase object. (Herdado de PermissionSetBase.)

Início

Operadores

  Nome Descrição
Operador públicoMembro estático Addition Creates a server permission set by performing an addition operation on a ServerPermission object and a ServerPermissionSet object.
Operador públicoMembro estático Equality Determines whether two objects are equal by performing an equality operation on two ServerPermissionSet objects.
Operador públicoMembro estático Inequality Determines whether two objects are unequal by performing an inequality operation on two ServerPermissionSet objects.
Operador públicoMembro estático Subtraction Creates a server permission set by performing a subtraction operation on a ServerPermission object and a ServerPermissionSet object.

Início

Comentários

Server permissions are required when you grant, deny, or revoke server-level permissions on an instance of SQL Server. The ServerPermissionSet object is required to specify the set of permissions that apply to the Grant method, the Deny method, and the Revoke method of the Server object.

Thread Safety

Qualquer membro público estático (Compartilhado no Microsoft Visual Basic) desse tipo é seguro para operações multi-threaded. Não há garantia de que qualquer membro de instância seja seguro para threads.

Exemplos

Concedendo, revogando e negando permissões

Segurança de thread

Qualquer membro público static (Shared no Visual Basic) desse tipo é seguro para threads. Não há garantia de que qualquer membro de instância seja seguro para threads.

Consulte também

Referência

Namespace Microsoft.SqlServer.Management.Smo

Outros recursos

Permissões (Mecanismo de Banco de Dados)

sys.server_permissions (Transact-SQL)