2.2.5.23 TablePermission Object

The TablePermission object defines the security rules of the Role object on the Table object. It is a child of a Role object.

The TablePermission object has the following properties.

Name

Type

Description

ID

unsignedLong

A reference to the object.

RoleID

unsignedLong

An ID-based reference to a Role object.

TableID

unsignedLong

An ID-based reference to a Table object.

FilterExpression

string

The DAX expression that filters the rows in the table when this security role is in effect.

ModifiedTime

dateTime

The time that the object was last modified.

State

enumeration

A value that provides information about the state of the permission. The possible values are as follows:

  • Ready (1) – The permission has a valid expression.

  • NoData (3) – Not applicable.

  • CalculationNeeded (4) – Not applicable.

  • SemanticError (5) – The expression of the TablePermission object has a semantic error. The table expression cannot be executed, and the role will not have access to the table.

  • EvaluationError (6) - Not applicable.

  • DependencyError (7) – A dependency associated with this TablePermission object is in an error state (SemanticError, EvaluationError, or DependencyError). The table expression cannot be executed, and the role will not have access to the table.

  • Incomplete (8) - Not applicable.

  • SyntaxError (9) - The TablePermission object is in an error state because of a syntax error in its expression. The TablePermission object is not queryable. This state applies only to TablePermission objects of the type Calculated. The table expression cannot be executed, and the role will not have access to the table.

ErrorMessage

string

A string that explains the error state associated with the current object. It is set by the engine only when the state of the object is one of these three values: SemanticError, DependencyError, or EvaluationError.

MetadataPermission<72>

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 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.