ServerPermissionSetValue Enumeration

The ServerPermissionSetValue enumeration is a list of constant values that specify all the database permissions.

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

Syntax

'Declaration
Public Enumeration ServerPermissionSetValue
'Usage
Dim instance As ServerPermissionSetValue

public enum ServerPermissionSetValue

public enum class ServerPermissionSetValue

type ServerPermissionSetValue

public enum ServerPermissionSetValue

Members

	Member name	Description
	AdministerBulkOperations	The ability to administer bulk operations.
	AlterAnyServerAudit	The ability to alter any server audit.
	AlterAnyCredential	The ability to alter any credential.
	AlterAnyConnection	The ability to alter any connection.
	AlterAnyDatabase	The ability to alter any database.
	AlterAnyEventNotification	The ability to alter any event notification.
	AlterAnyEndpoint	The ability to alter any endpoint.
	AlterAnyLogin	The ability to alter any login.
	AlterAnyLinkedServer	The ability to alter any linked server.
	AlterResources	The ability to alter resources.
	AlterServerState	The ability to alter the state of the server.
	AlterSettings	The ability to alter settings.
	AlterTrace	The ability to alter traces.
	AuthenticateServer	The ability to authenticate the server.
	ControlServer	The ability to control the server.
	ConnectSql	The ability to connect to SQL Server.
	CreateAnyDatabase	The ability to create any database.
	CreateDdlEventNotification	The ability to create data definition language (DDL) event notifications.
	CreateEndpoint	The ability to create endpoints.
	CreateTraceEventNotification	The ability to create trace event notifications.
	Shutdown	The ability to shut down the server.
	ViewAnyDefinition	The ability to view any definition.
	ViewAnyDatabase	The ability to view any database.
	ViewServerState	The ability to view the state of the server.
	ExternalAccessAssembly	Gets or sets the Boolean property value that specifies whether to include the EXTERNAL ACCESS (XA) permission in the permission set. This permission lets the grantee access external system resources such as assembly files, networks, environmental variables, and the registry.
	UnsafeAssembly	Gets or sets the Boolean property value that specifies whether to include the UNSAFE permission in the permission set. This permission allows the grantee unrestricted access to resources, both within and outside SQL Server, including calls to unmanaged code

Examples

Granting, Revoking, and Denying Permissions

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace