ServerPermission Class
The ServerPermission object represents a SQL Server server-level permission.
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
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(ServerPermission, ServerPermission) | Returns a set of server permissions after adding a new server permission to an existing set of server permissions. |
![]() ![]() | BitwiseOr(ServerPermission, ServerPermission) | Combines two Server Permissions using an inclusive OR. |
![]() | Equals(Object) | 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(ServerPermission) | 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(ServerPermission, ServerPermission) | Creates a server permission set by performing an addition operation on two ServerPermission objects. |
![]() ![]() | BitwiseOr(ServerPermission, ServerPermission) | Creates a server permission set by performing a bitwise OR operation on two ServerPermission objects. |
![]() ![]() | Equality(ServerPermission, ServerPermission) | 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(ServerPermission, ServerPermission) | 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.
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.
Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.