Object Protection

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,
- they must be defined in the following order with the following parameters.
- the DB pos. must be in the Pos. OS field of the first object protection DI (Created on).

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)

Upon creation of a record, 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. In case in the

Users: Object Protection/Data Table

module, an entry has been made for the user and the data table in question, the

OPC

field from this entry is used. An object protection class can belong to several users. By doing so, several program users are combined to form a so-called group. The object protection class has nothing to do with the user class of a user.

Owner

Describes what the creating user is allowed to do with the records he/she has created.

r = read
w = write/change
d = delete

The protection properties are specified in the following form:

rwd = reading, writing, and deletion allowed
rw- = reading and writing allowed
r-d = reading and deletion allowed
r-- = only reading allowed
The w and d rights must always be specified together with r, as a data record must be read before it can be changed or deleted. E.g., for deletion only you therefore have to specify r-d, not --d.

Group

Describes what a user may do with a record if their user object protection class matches the object protection class entered in the record. Values analogous to Owner (see above).

Any

The "any" authorization applies when the user is not the creating user of the record and does not have the same object protection class as the record. Values analoguos to Owner (see above).

Owner license

Upon the creation of a record, the current license is entered automatically. The license serves to distinguish standard records from individual records.