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
	AdministerBulkOperations	Gets a permission that can be included in the server permission set.
	AlterAnyAvailabilityGroup	Gets a permission that can be included in the server permission set.
	AlterAnyConnection	Gets a permission that can be included in the server permission set.
	AlterAnyCredential	Gets a permission that can be included in the server permission set.
	AlterAnyDatabase	Gets a permission that can be included in the server permission set.
	AlterAnyEndpoint	Gets a permission that can be included in the server permission set.
	AlterAnyEventNotification	Gets a permission that can be included in the server permission set.
	AlterAnyEventSession	Gets a permission that can be included in the server permission set.
	AlterAnyLinkedServer	Gets a permission that can be included in the server permission set.
	AlterAnyLogin	Gets a permission that can be included in the server permission set.
	AlterAnyServerAudit	Gets a permission that can be included in the server permission set.
	AlterAnyServerRole	Gets a permission that can be included in the server permission set.
	AlterResources	Gets a permission that can be included in the server permission set.
	AlterServerState	Gets a permission that can be included in the server permission set.
	AlterSettings	Gets a permission that can be included in the server permission set.
	AlterTrace	Gets a permission that can be included in the server permission set.
	AuthenticateServer	Gets a permission that can be included in the server permission set.
	ConnectSql	Gets a permission that can be included in the server permission set.
	ControlServer	Gets a permission that can be included in the server permission set.
	CreateAnyDatabase	Gets a permission that can be included in the server permission set.
	CreateAvailabilityGroup	Gets a permission that can be included in the server permission set.
	CreateDdlEventNotification	Gets a permission that can be included in the server permission set.
	CreateEndpoint	Gets a permission that can be included in the server permission set.
	CreateServerRole	Gets a permission that can be included in the server permission set.
	CreateTraceEventNotification	Gets a permission that can be included in the server permission set.
	ExternalAccessAssembly	Gets a permission that can be included in the server permission set.
	Shutdown	Gets a permission that can be included in the server permission set.
	UnsafeAssembly	Gets a permission that can be included in the server permission set.
	ViewAnyDatabase	Gets a permission that can be included in the server permission set.
	ViewAnyDefinition	Gets a permission that can be included in the server permission set.
	ViewServerState	Gets a permission that can be included in the server permission set.

Top

Methods

	Name	Description
	Add	Returns a set of server permissions after adding a new server permission to an existing set of server permissions.
	BitwiseOr	Combines two Server Permissions using an inclusive OR.
	Equals	Determines whether the referenced server permission object is equal to a specified object. (Overrides Object.Equals(Object).)
	GetHashCode	Do not reference this member directly in your code. It supports the SQL Server infrastructure. (Overrides Object.GetHashCode().)
	GetType	(Inherited from Object.)
	ToServerPermissionSet	Returns a set of server permissions based on a single server permission, by converting a ServerPermission object to a ServerPermissionSet object.
	ToString	(Inherited from Object.)

Top

Operators

	Name	Description
	Addition	Creates a server permission set by performing an addition operation on two ServerPermission objects.
	BitwiseOr	Creates a server permission set by performing a bitwise OR operation on two ServerPermission objects.
	Equality	Creates a server permission set by performing an equality operation on two ServerPermission objects.
	Implicit(ServerPermission to ServerPermissionSet)	Creates a new server permission set by implicitly converting server permission.
	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.

Examples

Granting, Revoking, and Denying Permissions

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.

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Granting, Revoking, and Denying Permissions

Permissions (Database Engine)