Dela via


ServerPermission Class

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

Inheritance Hierarchy

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

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

Syntax

'Declaration
Public NotInheritable Class ServerPermission
'Usage
Dim instance As ServerPermission
public sealed class ServerPermission
public ref class ServerPermission sealed
[<SealedAttribute>]
type ServerPermission =  class end
public final class ServerPermission

The ServerPermission type exposes the following members.

Properties

  Name Description
Public propertyStatic member AdministerBulkOperations Gets a permission that can be included in the server permission set.
Public propertyStatic member AlterAnyConnection Gets a permission that can be included in the server permission set.
Public propertyStatic member AlterAnyCredential Gets a permission that can be included in the server permission set.
Public propertyStatic member AlterAnyDatabase Gets a permission that can be included in the server permission set.
Public propertyStatic member AlterAnyEndpoint Gets a permission that can be included in the server permission set.
Public propertyStatic member AlterAnyEventNotification Gets a permission that can be included in the server permission set.
Public propertyStatic member AlterAnyLinkedServer Gets a permission that can be included in the server permission set.
Public propertyStatic member AlterAnyLogin Gets a permission that can be included in the server permission set.
Public propertyStatic member AlterAnyServerAudit Gets a permission that can be included in the server permission set.
Public propertyStatic member AlterResources Gets a permission that can be included in the server permission set.
Public propertyStatic member AlterServerState Gets a permission that can be included in the server permission set.
Public propertyStatic member AlterSettings Gets a permission that can be included in the server permission set.
Public propertyStatic member AlterTrace Gets a permission that can be included in the server permission set.
Public propertyStatic member AuthenticateServer Gets a permission that can be included in the server permission set.
Public propertyStatic member ConnectSql Gets a permission that can be included in the server permission set.
Public propertyStatic member ControlServer Gets a permission that can be included in the server permission set.
Public propertyStatic member CreateAnyDatabase Gets a permission that can be included in the server permission set.
Public propertyStatic member CreateDdlEventNotification Gets a permission that can be included in the server permission set.
Public propertyStatic member CreateEndpoint Gets a permission that can be included in the server permission set.
Public propertyStatic member CreateTraceEventNotification Gets a permission that can be included in the server permission set.
Public propertyStatic member ExternalAccessAssembly Gets a permission that can be included in the server permission set.
Public propertyStatic member Shutdown Gets a permission that can be included in the server permission set.
Public propertyStatic member UnsafeAssembly Gets a permission that can be included in the server permission set.
Public propertyStatic member ViewAnyDatabase Gets a permission that can be included in the server permission set.
Public propertyStatic member ViewAnyDefinition Gets a permission that can be included in the server permission set.
Public propertyStatic member ViewServerState Gets a permission that can be included in the server permission set.

Top

Methods

  Name Description
Public methodStatic member Add Returns a set of server permissions after adding a new server permission to an existing set of server permissions.
Public methodStatic member BitwiseOr Combines two Server Permissions using an inclusive OR.
Public method Equals Determines whether the referenced server permission object is equal to a specified object. (Overrides Object.Equals(Object).)
Protected method Finalize (Inherited from Object.)
Public method GetHashCode This method supports the SQL Server infrastructure and is not intended to be used directly from your code. (Overrides Object.GetHashCode().)
Public method GetType (Inherited from Object.)
Protected method MemberwiseClone (Inherited from Object.)
Public methodStatic member ToServerPermissionSet Returns a set of server permissions based on a single server permission, by converting a ServerPermission object to a ServerPermissionSet object.
Public method ToString (Inherited from Object.)

Top

Operators

  Name Description
Public operatorStatic member Addition Creates a server permission set by performing an addition operation on two ServerPermission objects.
Public operatorStatic member BitwiseOr Creates a server permission set by performing a bitwise OR operation on two ServerPermission objects.
Public operatorStatic member Equality Creates a server permission set by performing an equality operation on two ServerPermission objects.
Public operatorStatic member Implicit(ServerPermission to ServerPermissionSet) Transforms a single Server Permission to Server Permission Set.
Public operatorStatic member Inequality Creates a server permission set by performing an inequality operation on two ServerPermission objects.

Top

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.

Thread Safety

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