Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

ServerPermissionSet Class

The ServerPermissionSet object represents a set of server permissions.

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

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
public sealed class ServerPermissionSet : PermissionSetBase

The ServerPermissionSet type exposes the following members.

  NameDescription
Public methodServerPermissionSet()Initializes a new instance of the ServerPermissionSet class.
Public methodServerPermissionSet(ServerPermission)Initializes a new instance of the ServerPermissionSet class based on the specified permission.
Public methodServerPermissionSet(ServerPermission[])Initializes a new instance of the ServerPermissionSet class based on the specified set of permissions.
Public methodServerPermissionSet(ServerPermissionSet)Initializes a new instance of the ServerPermissionSet class based on the specified set of permissions.
Top
  NameDescription
Public propertyAdministerBulkOperationsGets 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.
Public propertyAlterAnyConnectionGets 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.
Public propertyAlterAnyCredentialGets 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.
Public propertyAlterAnyDatabaseGets 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.
Public propertyAlterAnyEndpointGets 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.
Public propertyAlterAnyEventNotificationGets 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.
Public propertyAlterAnyLinkedServerGets 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.
Public propertyAlterAnyLoginGets 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.
Public propertyAlterAnyServerAuditGets 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.
Public propertyAlterResourcesGets 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.
Public propertyAlterServerStateGets 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.
Public propertyAlterSettingsGets 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.
Public propertyAlterTraceGets 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.
Public propertyAuthenticateServerGets 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.
Public propertyConnectSqlGets 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.
Public propertyControlServerGets 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.
Public propertyCreateAnyDatabaseGets 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.
Public propertyCreateDdlEventNotificationGets 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.
Public propertyCreateEndpointGets 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.
Public propertyCreateTraceEventNotificationGets 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.
Public propertyExternalAccessAssemblyGets 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.
Public propertyShutdownGets 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.
Public propertyUnsafeAssemblyGets 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
Public propertyViewAnyDatabaseGets 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.
Public propertyViewAnyDefinitionGets 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.
Public propertyViewServerStateGets 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.
Top
  NameDescription
Public methodAdd(ServerPermission)Returns a server permission set after adding a new server permission to the referenced permission set.
Public methodStatic memberAdd(ServerPermissionSet, ServerPermission)Returns a server permission set after adding a new server permission to the specified permission set.
Public methodEqualsDetermines whether the referenced server permission object is equal to a specified object. (Overrides PermissionSetBase.Equals(Object).)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCodeDo not reference this member directly in your code. It supports the SQL Server infrastructure. (Overrides PermissionSetBase.GetHashCode().)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodRemoveRemoves a permission from the permission set.
Public methodStatic memberSubtractReturns a server permission set after subtracting a server permission from the specified permission set.
Public methodToStringReturns the string value that represents the specified PermissionSetBase object. (Inherited from PermissionSetBase.)
Top
  NameDescription
Public operatorStatic memberAdditionCreates a server permission set by performing an addition operation on a ServerPermission object and a ServerPermissionSet object.
Public operatorStatic memberEqualityDetermines whether two objects are equal by performing an equality operation on two ServerPermissionSet objects.
Public operatorStatic memberInequalityDetermines whether two objects are unequal by performing an inequality operation on two ServerPermissionSet objects.
Public operatorStatic memberSubtractionCreates a server permission set by performing a subtraction operation on a ServerPermission object and a ServerPermissionSet object.
Top

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

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.