Conditions

You can fine-tune rights by specifying special conditions, written in the form of SQL statements (a WHERE clause). These conditions describe the requirements that users must meet in order to be granted a particular right.

You could, for example, grant all members of a Sales user group the right to insert data into the Price field, but reserve the right to enter numbers higher than a certain amount for the manager (identified by means of his ID from the Employees table).

Any condition that you define must be checked for syntactical correctness before it takes effect. The N(o) value of the Correct field on the Restricting Conditions window will then be set to Y(es).

Note the following:

·	If, for certain rights, conditions are specified both at the table and column level, the column level condition overrules the table level condition.

·	You cannot define a condition for a column when you have defined a Select right for that column. It is possible, however, for other column level rights.

Restricting Conditions are included in the application even if they are not marked as Correct. This means that a query on the table to which the Condition applies may result in an error message. You must check that all conditions are marked Correct before applying them.