priv
- Last UpdatedNov 12, 2024
- 1 minute read
The priv table defines what privileges are available to groups and how the format of how each privilege is assigned during the configuration process (number, text, drop down list box etc.). This table is populated by a script after the database is created and the user has no ability to add, remove or change privileges as the software is coded to these predefined privileges.
As with the system_attr.description, the priv_desc text is not displayed externally, but language table entries are used instead.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
priv_id |
int32 |
Y |
N |
Identify the privilege |
|
priv_desc |
string80 |
N |
N |
Privilege description |
|
priv_grp |
string80 |
N |
N |
Allows privileges to be grouped when displayed |
|
edit_type |
int32 |
N |
N |
Enumeration of method used to edit the privilege: 1 = drop down, 2 = integer (i.e., typed in) 8 = checkbox. |
|
priv_constraints |
string254 |
N |
Y |
Extra editing data, e.g., set of values for DDLB, or min / max values, etc. |
|
reqd_lic |
string1700 |
N |
Y |
Which licenses are required for this privilege to be editable. Stored in format "base_prod enprod +" |