.png)
ServerPermission Class
SQL Server 2008 R2
The ServerPermission object represents a SQL Server server-level permission.
Namespace:
Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
The ServerPermission type exposes the following members.
| Name | Description | |
|---|---|---|
 | AdministerBulkOperations | 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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).) |
| Finalize | (Inherited from Object.) |
| GetHashCode | This method supports the SQL Server infrastructure and is not intended to be used directly from your code. (Overrides Object.GetHashCode().) |
| GetType | (Inherited from Object.) |
| MemberwiseClone | (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) | Transforms a single Server Permission to Server Permission Set. |
| 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.
