ServerPermission Class

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

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

Syntax

'Declaration
Public NotInheritable Class ServerPermission
public sealed class ServerPermission
public ref class ServerPermission sealed
public final class ServerPermission
public final class ServerPermission

Remarks

Updated text:

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.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Management.Smo.ServerPermission

Example

How to: Grant Server Permissions in Visual Basic .NET

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

ServerPermission Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Granting, Revoking, and Denying Permissions
Permissions
sys.server_permissions (Transact-SQL)

Change History

Release

History

New content:
  • Added Add method to the ServerPermission class.

  • Added ToServerPermissionSet method to the ServerPermissionSet class.