Restricting Conditions

A restricting condition is a SQL condition that restricts a given Table Right or Column Right to a specific subset of records in that table or that column.

As a first action, you define a restricting condition.

As a second action, you attach it to one or more Table Rights or Column Rights. Frequently, a given restricting condition is for a single Table Right.

To define a restricting condition:

1.	Choose Define, Conditions.

The Restricting Conditions window appears.

2.	Type a WHERE clause in the window. Do not type the word WHERE itself. If necessary, you can click the Edit button to open the Popup Text Editor.

3.	Save your changes.

4.	Make sure your Restricting Condition is checked. You can have conditions checked one-by-one, or as a batch. For more information, go to How to Check Conditions.

To attach a restricting condition to a Table Right:

1.	Get the correct Table Right in your screen. Do this by choosing Define, Table Rights from the menu, and then performing a query to retrieve the specific Table Right.

2.	Decide whether the condition is meant to restrict a foreground right or a background right.

3.	In the Condition ID group, in either the Foreground or Background field (depending on your decision in Step 2), type the ID of the Restricting Condition that you want to attach to the Table Right, or select it using the lookup button. Save.

To attach a restricting condition to a Column Right:

1.	Get the correct Column Right in your screen. Do this by choosing Define, Column Rights from the menu, and then performing a query to retrieve the specific Column Right.

2.	Decide whether the condition is meant to restrict a foreground right or a background right.

3.	In either the Frgrnd Condition ID or the Bakgrnd Condition ID (depending on your decision in Step 2), type the ID of the Restricting Condition that you want to attach to the Column Right, or select it using the lookup button. Save.