ServerPermission Class

SQL Server 2014

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

Inheritance Hierarchy

Object
Microsoft.SqlServer.Management.Smo.ServerPermission

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

Syntax

C++

JScript

public sealed class ServerPermission

The ServerPermission type exposes the following members.

	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.
	ConnectAnyDatabase	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.
	ImpersonateAnyLogin	Gets a permission that can be included in the server permission set.
	SelectAllUserSecurables	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.

	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 ObjectEquals(Object).)
	GetHashCode	Do not reference this member directly in your code. It supports the SQL Server infrastructure. (Overrides ObjectGetHashCode.)
	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.)

	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.

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.