Column rights

A column right is a restriction or denial of data access to a column that a usergroup would normally have on the basis of a table right. Thus, a column right restricts a table right.

The first four (4) access modes (SELECT, INSERT, UPDATE, DELETE) are mutually exclusive. ALL is a shortcut for the combination of SELECT, INSERT, UPDATE and DELETE.

In addition to access mode, the effect of each Column Right is determined by its scope.

To define a column right:

1.	Choose Define, Column Rights.

The Column Rights window appears.

2.	Complete the dialog as follows:

•Enter the name of the application, or click the Lookup button to choose one from the list.

•Enter the name of a user group, or click the Lookup button to choose one from the list.

•Enter the name of a table, or click the Lookup button to choose one from the list.

•Specify the column in the Column Name field, and then, in the Access Right field, specify which right you want to grant at the column level (Lookup buttons are available on both fields).

•Set a Scope setting.

•If any (previously defined) conditions apply to the foreground, and background rights, enter their IDs by means of the Lookup buttons on the Frgrnd Condition ID, and Bckgrnd Condition ID fields.

3.	Save your changes.