ServerPermission ServerPermission ServerPermission Class

Definition

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

public ref class ServerPermission sealed
public sealed class ServerPermission
Public NotInheritable Class ServerPermission
Inheritance
ServerPermissionServerPermissionServerPermission

Examples

Granting, Revoking, and Denying Permissions

Remarks

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.

Properties

AdministerBulkOperations AdministerBulkOperations AdministerBulkOperations

Gets a permission that can be included in the server permission set.

AlterAnyAvailabilityGroup AlterAnyAvailabilityGroup AlterAnyAvailabilityGroup

Gets a permission that can be included in the server permission set.

AlterAnyConnection AlterAnyConnection AlterAnyConnection

Gets a permission that can be included in the server permission set.

AlterAnyCredential AlterAnyCredential AlterAnyCredential

Gets a permission that can be included in the server permission set.

AlterAnyDatabase AlterAnyDatabase AlterAnyDatabase

Gets a permission that can be included in the server permission set.

AlterAnyEndpoint AlterAnyEndpoint AlterAnyEndpoint

Gets a permission that can be included in the server permission set.

AlterAnyEventNotification AlterAnyEventNotification AlterAnyEventNotification

Gets a permission that can be included in the server permission set.

AlterAnyEventSession AlterAnyEventSession AlterAnyEventSession

Gets a permission that can be included in the server permission set.

AlterAnyLinkedServer AlterAnyLinkedServer AlterAnyLinkedServer

Gets a permission that can be included in the server permission set.

AlterAnyLogin AlterAnyLogin AlterAnyLogin

Gets a permission that can be included in the server permission set.

AlterAnyServerAudit AlterAnyServerAudit AlterAnyServerAudit

Gets a permission that can be included in the server permission set.

AlterAnyServerRole AlterAnyServerRole AlterAnyServerRole

Gets a permission that can be included in the server permission set.

AlterResources AlterResources AlterResources

Gets a permission that can be included in the server permission set.

AlterServerState AlterServerState AlterServerState

Gets a permission that can be included in the server permission set.

AlterSettings AlterSettings AlterSettings

Gets a permission that can be included in the server permission set.

AlterTrace AlterTrace AlterTrace

Gets a permission that can be included in the server permission set.

AuthenticateServer AuthenticateServer AuthenticateServer

Gets a permission that can be included in the server permission set.

ConnectAnyDatabase ConnectAnyDatabase ConnectAnyDatabase

Gets a permission that can be included in the server permission set.

ConnectSql ConnectSql ConnectSql

Gets a permission that can be included in the server permission set.

ControlServer ControlServer ControlServer

Gets a permission that can be included in the server permission set.

CreateAnyDatabase CreateAnyDatabase CreateAnyDatabase

Gets a permission that can be included in the server permission set.

CreateAvailabilityGroup CreateAvailabilityGroup CreateAvailabilityGroup

Gets a permission that can be included in the server permission set.

CreateDdlEventNotification CreateDdlEventNotification CreateDdlEventNotification

Gets a permission that can be included in the server permission set.

CreateEndpoint CreateEndpoint CreateEndpoint

Gets a permission that can be included in the server permission set.

CreateServerRole CreateServerRole CreateServerRole

Gets a permission that can be included in the server permission set.

CreateTraceEventNotification CreateTraceEventNotification CreateTraceEventNotification

Gets a permission that can be included in the server permission set.

ExternalAccessAssembly ExternalAccessAssembly ExternalAccessAssembly

Gets a permission that can be included in the server permission set.

ImpersonateAnyLogin ImpersonateAnyLogin ImpersonateAnyLogin

Gets a permission that can be included in the server permission set.

SelectAllUserSecurables SelectAllUserSecurables SelectAllUserSecurables

Gets a permission that can be included in the server permission set.

Shutdown Shutdown Shutdown

Gets a permission that can be included in the server permission set.

UnsafeAssembly UnsafeAssembly UnsafeAssembly

Gets a permission that can be included in the server permission set.

ViewAnyDatabase ViewAnyDatabase ViewAnyDatabase

Gets a permission that can be included in the server permission set.

ViewAnyDefinition ViewAnyDefinition ViewAnyDefinition

Gets a permission that can be included in the server permission set.

ViewServerState ViewServerState ViewServerState

Gets a permission that can be included in the server permission set.

Methods

Add(ServerPermission, ServerPermission) Add(ServerPermission, ServerPermission) Add(ServerPermission, ServerPermission)

Returns a set of server permissions after adding a new server permission to an existing set of server permissions.

BitwiseOr(ServerPermission, ServerPermission) BitwiseOr(ServerPermission, ServerPermission) BitwiseOr(ServerPermission, ServerPermission)

Combines two Server Permissions using an inclusive OR.

Equals(Object) Equals(Object) Equals(Object)

Determines whether the referenced server permission object is equal to a specified object.

GetHashCode() GetHashCode() GetHashCode()

Do not reference this member directly in your code. It supports the SQL Server infrastructure.

ToServerPermissionSet(ServerPermission) ToServerPermissionSet(ServerPermission) ToServerPermissionSet(ServerPermission)

Returns a set of server permissions based on a single server permission, by converting a ServerPermission object to a ServerPermissionSet object.

Operators

Addition(ServerPermission, ServerPermission) Addition(ServerPermission, ServerPermission) Addition(ServerPermission, ServerPermission)

Creates a server permission set by performing an addition operation on two ServerPermission objects.

BitwiseOr(ServerPermission, ServerPermission) BitwiseOr(ServerPermission, ServerPermission) BitwiseOr(ServerPermission, ServerPermission)

Creates a server permission set by performing a bitwise OR operation on two ServerPermission objects.

Equality(ServerPermission, ServerPermission) Equality(ServerPermission, ServerPermission) Equality(ServerPermission, ServerPermission)

Creates a server permission set by performing an equality operation on two ServerPermission objects.

Implicit(ServerPermission to ServerPermissionSet) Implicit(ServerPermission to ServerPermissionSet) Implicit(ServerPermission to ServerPermissionSet)

Creates a new server permission set by implicitly converting server permission.

Inequality(ServerPermission, ServerPermission) Inequality(ServerPermission, ServerPermission) Inequality(ServerPermission, ServerPermission)

Creates a server permission set by performing an inequality operation on two ServerPermission objects.

Applies to