Next, plan each DBF table’s privilege scheme.

For each table operation, determine the most restricted access level that can perform the operation. All levels less restricted than the specified one can perform that operation; all levels more restricted than the specified level cannot.

The following worksheet illustrates one way to plan which user access levels grant which table rights.

Table

Read

Update

Extend

Delete

CUSTOMER

8

4

4

1

PRODUCT

8

4

4

1

ORDERS

8

4

4

1