Role conditions

Previous Next

A role condition is a SQL condition attached to a Table Right.

A role condition restricts the access afforded by the Table Right. Without the condition, the right would cover all the records in the table. With the condition attached, it covers only the subset of records that satisfy the condition.

The condition is like a WHERE clause that would restrict a query result to that subset of records if it were used as part of an explicit SQL SELECT statement.

 

 

collapseSyntax
collapseScope of role conditions
collapseDefining a role condition

 

 

See also

Roles