In the table list, select the table for which access privileges are to be granted and select the Relships / Privileges function. The privileges define which users are authorized to access particular columns of a table. Privileges describe the relationship between users and tables. Thus, the Privileges function is available in the object list under the Relships menu item. The Relships / Privileges function modifies the User uses Table and User uses Column relationships.
When you select the Relships / Privileges function, the list of all privileges granted for this table is displayed in tabular form. This list contains at least one entry since, otherwise, it would not be possible to access the table for which you would like to view or modify the privileges. If you yourself are the table owner or if you have the GRANT privilege for this table, you can now extend the list of privileges.
To define the access privileges for an additional user, enter the username, privilege type, and, if appropriate, the columns of the table, for each line. A number of privilege types can be entered as a list of privileges. The selection of table columns is also defined as a list of names with the same format.
If no column names are defined, the privilege applies to the entire table. For each user, you can enter as many lines as necessary for defining the various access privileges to the table columns.
To delete access privileges, delete the lines that define them by using Edit / Delete and exit the privilege window by selecting Object / Save.
As soon as a box with the User heading is activated, the 
button appears. Click on it to obtain a list of all users and usergroups; you can then select the relevant users
from this list. The keyword "public" means that the access privilege is granted to all users (present and future).
After clicking on the 
toolbar button, the privileges can also be selected from the privileges form by checking them (ALL, SELECT, INSERT, DELETE, UPDATE, SELUPD, REFERENCES, INDEX,
ALTER). Only those privilege types actually available in the context are offered, e.g., the "ins", "ind", and "alt" privileges are available only if you yourself have these privileges.
When you select the SELECT, UPDATE, or SELUPD privilege type, you can also define the columns to which the privilege is to apply. Click on the 
button to display a list of all the
columns in the table under the Column heading. Select the desired columns using the arrow buttons; the sequence is irrelevant. The columns thus selected are listed in the tabular display of
privileges on one line, separated by semicolons.
