DatabasePermissionInfo Class

The DatabasePermissionInfo object represents information about a SQL Server database permission.

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Management.Smo.PermissionInfo
    Microsoft.SqlServer.Management.Smo.DatabasePermissionInfo

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

Syntax

'Declaration
Public Class DatabasePermissionInfo _
    Inherits PermissionInfo
'Usage
Dim instance As DatabasePermissionInfo
public class DatabasePermissionInfo : PermissionInfo
public ref class DatabasePermissionInfo : public PermissionInfo
type DatabasePermissionInfo =  
    class 
        inherit PermissionInfo 
    end
public class DatabasePermissionInfo extends PermissionInfo

The DatabasePermissionInfo type exposes the following members.

Constructors

  Name Description
Public method DatabasePermissionInfo Initializes a new instance of the DatabasePermissionInfo class.

Top

Properties

  Name Description
Public property ColumnName Gets the name of the column that has permissions granted or denied. (Inherited from PermissionInfo.)
Public property Grantee Gets the name of the database user, logon, or database role who has been granted or denied access to the object. (Inherited from PermissionInfo.)
Public property GranteeType Gets the type of grantee. (Inherited from PermissionInfo.)
Public property Grantor Gets the name of the database user, logon, or database role who granted or denied access to the object. (Inherited from PermissionInfo.)
Public property GrantorType Gets the type of grantor. (Inherited from PermissionInfo.)
Public property ObjectClass Gets the object class for the object to which permissions have been granted or denied. (Inherited from PermissionInfo.)
Public property ObjectID Gets the ID value that uniquely identifies the object to which the permission applies. (Inherited from PermissionInfo.)
Public property ObjectName Gets the name of the object to which the permission applies. (Inherited from PermissionInfo.)
Public property ObjectSchema Gets the schema of the object to which the permission applies. (Inherited from PermissionInfo.)
Public property PermissionState Gets the permission state of the object to which the permission applies, such as whether the permission is granted, denied, granted with grant, or revoked. (Inherited from PermissionInfo.)
Public property PermissionType Gets the type of permission.
Protected property PermissionTypeInternal Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. (Inherited from PermissionInfo.)

Top

Methods

  Name Description
Public method Equals (Inherited from Object.)
Protected method Finalize (Inherited from Object.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Protected method MemberwiseClone (Inherited from Object.)
Public method ToString Returns the object as a String value. (Inherited from PermissionInfo.)

Top

Remarks

The DatabasePermissionInfo class is served by the EnumDatabasePermissions method.

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.

Examples

Granting, Revoking, and Denying Permissions

Thread Safety

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

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Permissions (Database Engine)