Export (0) Print
Expand All

ServerPermission Class

The ServerPermission object represents a SQL Server server-level permission.

System.Object
  Microsoft.SqlServer.Management.Smo.ServerPermission

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

public sealed class ServerPermission

The ServerPermission type exposes the following members.

  NameDescription
Public propertyStatic memberAdministerBulkOperationsGets a permission that can be included in the server permission set.
Public propertyStatic memberAlterAnyConnectionGets a permission that can be included in the server permission set.
Public propertyStatic memberAlterAnyCredentialGets a permission that can be included in the server permission set.
Public propertyStatic memberAlterAnyDatabaseGets a permission that can be included in the server permission set.
Public propertyStatic memberAlterAnyEndpointGets a permission that can be included in the server permission set.
Public propertyStatic memberAlterAnyEventNotificationGets a permission that can be included in the server permission set.
Public propertyStatic memberAlterAnyLinkedServerGets a permission that can be included in the server permission set.
Public propertyStatic memberAlterAnyLoginGets a permission that can be included in the server permission set.
Public propertyStatic memberAlterAnyServerAuditGets a permission that can be included in the server permission set.
Public propertyStatic memberAlterResourcesGets a permission that can be included in the server permission set.
Public propertyStatic memberAlterServerStateGets a permission that can be included in the server permission set.
Public propertyStatic memberAlterSettingsGets a permission that can be included in the server permission set.
Public propertyStatic memberAlterTraceGets a permission that can be included in the server permission set.
Public propertyStatic memberAuthenticateServerGets a permission that can be included in the server permission set.
Public propertyStatic memberConnectSqlGets a permission that can be included in the server permission set.
Public propertyStatic memberControlServerGets a permission that can be included in the server permission set.
Public propertyStatic memberCreateAnyDatabaseGets a permission that can be included in the server permission set.
Public propertyStatic memberCreateDdlEventNotificationGets a permission that can be included in the server permission set.
Public propertyStatic memberCreateEndpointGets a permission that can be included in the server permission set.
Public propertyStatic memberCreateTraceEventNotificationGets a permission that can be included in the server permission set.
Public propertyStatic memberExternalAccessAssemblyGets a permission that can be included in the server permission set.
Public propertyStatic memberShutdownGets a permission that can be included in the server permission set.
Public propertyStatic memberUnsafeAssemblyGets a permission that can be included in the server permission set.
Public propertyStatic memberViewAnyDatabaseGets a permission that can be included in the server permission set.
Public propertyStatic memberViewAnyDefinitionGets a permission that can be included in the server permission set.
Public propertyStatic memberViewServerStateGets a permission that can be included in the server permission set.
Top

  NameDescription
Public methodStatic memberAddReturns a set of server permissions after adding a new server permission to an existing set of server permissions.
Public methodStatic memberBitwiseOrCombines two Server Permissions using an inclusive OR.
Public methodEqualsDetermines whether the referenced server permission object is equal to a specified object. (Overrides Object.Equals(Object).)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCodeThis method supports the SQL Server infrastructure and is not intended to be used directly from your code. (Overrides Object.GetHashCode().)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodStatic memberToServerPermissionSetReturns a set of server permissions based on a single server permission, by converting a ServerPermission object to a ServerPermissionSet object.
Public methodToString (Inherited from Object.)
Top

  NameDescription
Public operatorStatic memberAdditionCreates a server permission set by performing an addition operation on two ServerPermission objects.
Public operatorStatic memberBitwiseOrCreates a server permission set by performing a bitwise OR operation on two ServerPermission objects.
Public operatorStatic memberEqualityCreates a server permission set by performing an equality operation on two ServerPermission objects.
Public operatorStatic memberImplicit(ServerPermission to ServerPermissionSet)Transforms a single Server Permission to Server Permission Set.
Public operatorStatic memberInequalityCreates a server permission set by performing an inequality operation on two ServerPermission objects.
Top

Server permissions are required when granting, denying, or revoking server-level permissions on an instance of SQL Server. The ServerPermission object is used to specify the set of permissions that apply to the Grant, Deny, and Revoke methods of the Server object. Also, server permissions can be added to the ServerPermissionSet object, which can also be used with the Deny, Revoke, and Grant methods.

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.

Community Additions

ADD
Show:
© 2014 Microsoft