2.2.5.27 ColumnPermission Object

The ColumnPermission object defines the security rules of the Role object on the Column object. It is a child of a TablePermission object and requires compatibility level 1400 or higher.<81>

Name

Type

Description

ID

unsignedLong

A reference to the object.

TablePermissionID

unsignedLong

An ID-based reference to a TablePermission object.

ColumnID

unsignedLong

An ID-based reference to a Column object.

ModifiedTime

dateTime

The time that the object was last modified.

MetadataPermission

enumeration

A value that establishes the permission level that is granted to a user in a particular role in accessing a table’s metadata and column's metadata and the data it defines.

The possible values are as follows:

  • Default (0) – The access that is granted is derived from the Model object’s permission of the role.

  • None (1) – No access is granted.

  • Read (2) – Read access is granted.