Information
-
In the object protection data fields, information on the record is saved, e.g. by whom/when it was created or changed, or, according to the license, whether it is a standard record or an individual record.
-
A data table does not have to contain object protection data fields.
Details
-
If a data table has object protection data fields,
|
Data item |
DI Python ID |
SQL ID |
Column type |
DB length |
DF length |
Status |
|---|---|---|---|---|---|---|
|
Created on |
created_on |
OS_CREATED_ON |
Date |
4 |
8 |
6 |
|
Changed on |
modified_on |
OS_MODIFIED_ON |
Date |
4 |
8 |
6 |
|
Created by |
created_by |
OS_CREATED_BY |
Alpha, large |
20 |
20 |
6 |
|
Modified by |
modified_by |
OS_MODIFIED_BY |
Alpha, large |
20 |
20 |
6 |
|
Owner license |
owner_license |
OS_LICENSE |
Alpha, large |
4 |
4 |
6 |
|
OPC |
opc |
OS_OPC |
Alpha, large |
8 |
8 |
6 |
|
Owner |
owner |
OS_OWNER |
Object protection for "rwd" output |
2 |
4 |
6 |
|
Group |
group |
OS_GROUP |
Object protection for "rwd" output |
2 |
4 |
6 |
|
Any |
any |
OS_ANY |
Object protection for "rwd" output |
2 |
4 |
6 |
Object Protection Data Fields
Created by (creating user)
When a record is created, the ID (code) of the logged-on user is automatically entered in this field. The creating user is also the owner of a record.
Created on (creation date)
When a record is created, the time of creation is automatically entered here.
Modified by (modifying user)
When a record is modified, the ID (code) of the logged-on user is automatically entered in this field.
Modified on (modification date)
When a record is modified, the modification date is automatically entered here.
OPC (object protection class)
The content of this data field is set to the user object protection class of the creating user. If an entry has been made for the user and for the data table in question in the Users: Object Protection/Data Table module, the OPC field from this entry will be used. An object protection class can belong to several users. In doing so, several program users will be combined in a so called group. The object protection class is not related to the user class of a user.
Owner
Specifies what actions are permitted for records if the user created them himself / herself:
-
r = read
-
w = write/change
-
d = delete
The protection characteristics are shown as follows:
-
rwd = reading, writing, and deletion permitted
-
rw- = reading and writing permitted
-
r-d = reading and deletion permitted
-
r-- = reading permitted only
-
The w and d rights must always be specified together with r, since a record must be read to be changeable/deletable. Hence, to specify "delete only" it is necessary to specify r-d and not merely --d.
group
Describes what a user is allowed to do with a record if his/her object protection class matches the object protection class entry in the record. Values analogous to Owner (see above).
any
The authorization for any will apply if the user is not the creating user for the record and does not have the same object protection class as that for the record. Values analogous to Owner (see above).
Owner license
Upon creation of a record, the current license is entered automatically. You can distinguish standard records from individual records by their license.