ObjectPermissionInfo Class

The ObjectPermissionInfo object represents information about a SQL Server object permission.

Inheritance Hierarchy

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

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

Syntax

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

The ObjectPermissionInfo type exposes the following members.

Constructors

  Name Description
Public method ObjectPermissionInfo Initializes a new instance of the ObjectPermissionInfo 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 ObjectPermissionInfo object is returned by the EnumObjectPermissions method. It works in a similar way to the ServerPermissionInfo object and the EnumServerPermissions method shown in the example.

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.

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

Granting, Revoking, and Denying Permissions