objekte

Holds the rights clauses (permission rules) for each combination of user group and enaio® object type. A clause is a filter condition appended to DMS queries that determines which records of an object type the respective group is allowed to see or edit. The table also holds the corresponding base rights bits and a bitmask of annotation rights.

1. Columns

Name Type Length Description

Name	Type	Length	Description
`gruppen_id`	`int`	—	Reference to `gruppen.id` — the user group the clauses and rights apply to.
`objekttyp`	`int`	—	enaio® object type ID (see Object type ID) the rules apply to.
`rechte`	`smallint`	—	Bitmask of the group’s base rights on the object type: `1` = export/open object (`X`) `2` = delete object (`D`) `4` = write index data (`R`) `8` = show index data (`R`) `16` = write object (`U`)
`clause`	`image`	max	Presumably obsolete — `NULL` in all known examples.
`hlp_clause`	`image`	max	Clause: show index data (right `R`).
`str_clause`	`nvarchar`	248	Obsolete — empty in current systems. Used to hold the previous clause format.
`annotations`	`int`	—	Bitmask of annotation rights. Only present for document object types. `1` = group annotations (right `G`) `2` = public annotations
`write_clause`	`image`	max	Clause: write index data (right `R`).
`delete_clause`	`image`	max	Clause: delete object (right `D`).
`obread_clause`	`image`	max	Clause: export/open object (right `X`).
`obwrite_clause`	`image`	max	Clause: write object (right `U`).
`new`	`int`	—	Unknown; `0` in all known examples.

gruppen_id

int

—

Reference to gruppen.id — the user group the clauses and rights apply to.

objekttyp

int

—

enaio® object type ID (see Object type ID) the rules apply to.

rechte

smallint

—

Bitmask of the group’s base rights on the object type:
1 = export/open object (X)
2 = delete object (D)
4 = write index data (R)
8 = show index data (R)
16 = write object (U)

clause

image

max

Presumably obsolete — NULL in all known examples.

hlp_clause

image

max

Clause: show index data (right R).

str_clause

nvarchar

248

Obsolete — empty in current systems. Used to hold the previous clause format.

annotations

int

—

Bitmask of annotation rights. Only present for document object types.
1 = group annotations (right G)
2 = public annotations

write_clause

image

max

Clause: write index data (right R).

delete_clause

image

max

Clause: delete object (right D).

obread_clause

image

max

Clause: export/open object (right X).

obwrite_clause

image

max

Clause: write object (right U).

new

int

—

Unknown; 0 in all known examples.

2. Related Tables

gruppen — the user groups referenced by gruppen_id.