PermissionInfo Class

The PermissionInfo class represents information regarding granted or denied privileges.

Inheritance Hierarchy

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

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

Syntax

'Declaration
Public Class PermissionInfo
'Usage
Dim instance As PermissionInfo
public class PermissionInfo
public ref class PermissionInfo
type PermissionInfo =  class end
public class PermissionInfo

The PermissionInfo type exposes the following members.

Properties

  Name Description
Public property ColumnName Gets the name of the column that has permissions granted or denied.
Public property Grantee Gets the name of the database user, logon, or database role who has been granted or denied access to the object.
Public property GranteeType Gets the type of grantee.
Public property Grantor Gets the name of the database user, logon, or database role who granted or denied access to the object.
Public property GrantorType Gets the type of grantor.
Public property ObjectClass Gets the object class for the object to which permissions have been granted or denied.
Public property ObjectID Gets the ID value that uniquely identifies the object to which the permission applies.
Public property ObjectName Gets the name of the object to which the permission applies.
Public property ObjectSchema Gets the schema of the object to which the permission applies.
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.
Protected property PermissionTypeInternal Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

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. (Overrides Object.ToString().)

Top

Remarks

The PermissionInfo object is returned by the EnumObjectPermissions method.

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

sys.syspermissions (Transact-SQL)