Topic group Related topics

Next, think about how much access each user needs to the table.

Although there are 8 access levels, you might choose to standardize on just 3 levels; one for full access, one for typical use, and one for minimal access. The next table shows the sample worksheet, expanded to show user access levels.

Table

Group

User name

Level 1
(full access)

Level 4
(typical access)

Level 8
(minimal access)

CUSTOMER

SALES

AMORRIS

X

 

 

 

 

BBISSING

 

X

 

 

 

LJACUS

X

 

 

 

 

FFINE

 

 

X

PRODUCT

ALL

AMORRIS

X

 

 

 

 

BANDERS

 

X

 

 

 

BBISSING

 

X

 

 

 

CDORFFI

 

X

 

 

 

LJACUS

X

 

 

 

 

FFINE

 

 

X