TABLE_ACCESS Table
The WORKPLACE_ACCESS schema expands upon the WDO, containing security information for the root level work nodes. It is used to obtain a list of "Workplace" tables within the Persistent Storage Location (PSL). Each workplace table within the PSL is represented by a single row in this table. The primary identifier of each workplace table in the WORKPLACE_ACCESS table is in the _C_TABLE_CD_ column. All messages that need to point to a specific workplace table will use this identifier. For example, in the <key> element of many messages this identifier is represented as
C_TABLE_NAME_ (see messaging specification). Within the _C_TABLE_NAME column is the actual name in the PSL of the workplace table. The _C_PROTECTED_ACCESS_ column designates whether one must have the protected access role (DATA_PROT) to obtain data from this table. The other columns are defined in a similar manner to the columns of the Metadata table, with the following special notes:
The _C_HLEVEL_ is almost always 0 in this table.
WORKPLACE_ACCESS |
|
| |
|---|---|---|---|
PK | C_INDEX | VARCHAR(255) |
|
| C_TABLE_CD | VARCHAR(255) |
|
| C_TABLE_NAME | VARCHAR(255) |
|
| C_PROTECTED_ACCESS | CHAR(1) |
|
| C_HLEVEL | INT |
|
| C_NAME | VARCHAR(255) |
|
| C_USER_ID | VARCHAR(255) |
|
| C_GROUP_ID | VARCHAR(255) |
|
| C_SHARE_ID | VARCHAR(255) |
|
| C_VISUALATTRIBUTES | CHAR(3) |
|
| C_PARENT_INDEX | VARCHAR(255) |
|
| C_TOOLTIP | VARCHAR(255) |
|
| C_ENTRY_DATE | DATE |
|
| C_CHANGE_DATE | DATE |
|
| C_STATUS_CD | CHAR(1) |
|