For each type of table operation (see the table below), specify the most restricted access level that can perform that operation.

Privilege

Access granted

READ

View the table contents

UPDATE

Edit existing records in the table

EXTEND

Add records to the table

DELETE

Delete records from the table

To set table privileges, select a value (1–8) for each operation (Read, Update, Extend and Delete) in the dialog box. Remember that lower access numbers indicate the greatest access; higher numbers indicate the greatest restriction.

Note

You cannot specify access levels that are logically incompatible. For example, you cannot prohibit Level 6 from having read access, and also permit Level 6 to have update access. To have update access, Level 6 also needs read access.