iX V6.5 (30391-90011)

58 Chapter2

Database Structure and Protection

Protecting the Database

Table 2-4. contains more illustrations of the effects of read and write class lists. These are

general examples that are not based on the ORDERS database shown in this manual.

Note that these examples take into account the effects of the access mode in which the

database is opened. The database creator and user class 9 (in access mode 1, 3, or 4) have

complete access to data set 1, but only the creator has complete access to data set 2.

Complete access includes the ability to add and delete entries, read all items, and update

the values of all items with the following exceptions. Master data set key item values

cannot be updated. Detail data set search and sort item values can be updated only in

database access mode 1, 3, or 4, and only if permitted by the CIUPDATE option settings for

the database and the current process. Note that except where user class 9 is speciﬁcally

identiﬁed in a read and write class list, user class 9 has complete access to data set 1 only

when the database access mode is 1, 3, or 4.

Table 2-4. Sample Read and Write Class Lists

Data Item Read/Write List Item Read Access

Item Update Access

a. User has access only if the database access mode is 1, 2, 3, or 4. For access modes 1, 3,

and 4, the CIUPDATE option settings for the database and the current process need to

permit updates of any items that are detail data set search or sort items.

Data Set 1 (0,18,13/9)

A 0,13,18,9

b. User has access only if the database access mode is 1, 3, or 4. For update access, the

CIUPDATE option settings for the database and the current process need to permit

updates of any items that are detail data set search or sort items.

B (13/) 13,9 9

C (/) 9 9

D (/19) 9 9

E (18/13) 13,18,9 13,9

F (/13,18) 13,18,9 13,18,9

G (12/0) 0,9 0,9

H (13/) 13,9 9

Data Set 2

c. Data set 2 has an absent list. The database creator has full access to the data set if the

database access mode is 1, 3, or 4. If the database is opened in access mode 2, the user

has item update access to all items, except master data set key items or detail data set

search and sort items even if the CIUPDATE option settings for the database and the

current process permit updates of search and sort item values.

A 0,1,. . .,63

I (13/9) 13,9 9