Partager via

  • Article

Classe ServerPermissionSet

The ServerPermissionSet object represents a set of server permissions.

Hiérarchie d'héritage

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

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
Public NotInheritable Class ServerPermissionSet _
    Inherits PermissionSetBase
'Utilisation
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

Le type ServerPermissionSet expose les membres suivants.

Constructeurs

  Nom Description
Méthode publique ServerPermissionSet() () () () Initializes a new instance of the ServerPermissionSet class.
Méthode publique ServerPermissionSet(ServerPermission) Initializes a new instance of the ServerPermissionSet class based on the specified permission.
Méthode publique ServerPermissionSet(array<ServerPermission> [] () [] []) Initializes a new instance of the ServerPermissionSet class based on the specified set of permissions.
Méthode publique ServerPermissionSet(ServerPermissionSet) Initializes a new instance of the ServerPermissionSet class based on the specified set of permissions.

Haut de la page

Propriétés

  Nom Description
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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 linked server on the instance of SQL Server.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique AuthenticateServer 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.

Haut de la page

Méthodes

  Nom Description
Méthode publique Add(ServerPermission) Returns a server permission set after adding a new server permission to the referenced permission set.
Méthode publiqueMembre statique Add(ServerPermissionSet, ServerPermission) Returns a server permission set after adding a new server permission to the specified permission set.
Méthode publique Equals Determines whether the referenced server permission object is equal to a specified object. (remplace PermissionSetBase. . :: . .Equals(Object).)
Méthode protégée Finalize (hérité de Object.)
Méthode publique GetHashCode Ne référencez pas directement ce membre dans votre code. Il prend en charge l'infrastructure SQL Server. (remplace PermissionSetBase. . :: . .GetHashCode() () () ().)
Méthode publique GetType (hérité de Object.)
Méthode protégée MemberwiseClone (hérité de Object.)
Méthode publique Remove Removes a permission from the permission set.
Méthode publiqueMembre statique Subtract Returns a server permission set after subtracting a server permission from the specified permission set.
Méthode publique ToString Retourne la valeur de chaîne qui représente l'objet PermissionSetBase spécifié. (hérité de PermissionSetBase.)

Haut de la page

Opérateurs

  Nom Description
Opérateur publicMembre statique Addition Creates a server permission set by performing an addition operation on a ServerPermission object and a ServerPermissionSet object.
Opérateur publicMembre statique Equality Determines whether two objects are equal by performing an equality operation on two ServerPermissionSet objects.
Opérateur publicMembre statique Inequality Determines whether two objects are unequal by performing an inequality operation on two ServerPermissionSet objects.
Opérateur publicMembre statique Subtraction Creates a server permission set by performing a subtraction operation on a ServerPermission object and a ServerPermissionSet object.

Haut de la page

Notes

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

Tout membre statique public (Partagé dans Microsoft Visual Basic) de ce type est sûr dans le cadre des opérations à plusieurs threads. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.

Sécurité des threads

Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.