Message-ID: <448745461.8568.1711708593103.JavaMail.confluence@ip-172-30-4-17.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8567_581630619.1711708593101" ------=_Part_8567_581630619.1711708593101 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html TABLE_ACCESS Table

TABLE_ACCESS Table

The WORKPLACE_ACCESS schema expands upon the WD= O, containing security information for the root level work nodes. It is use= d to obtain a list of "Workplace" tables within the Persistent Stor= age Location (PSL). Each workplace table within the PSL is represe= nted by a single row in this table. The primary identifier of each workplac= e table in the WORKPLACE_ACCESS table is in the _C_TABLE_C= D_ column. All messages that need to point to a specific workplace table wi= ll use this identifier. For example, in the <key> element of many mes= sages 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_PROTE= CTED_ACCESS_ column designates whether one must have the protected access r= ole (DATA_PROT) to obtain data from this table. The other columns are defin= ed in a similar manner to the columns of the Metadata table, with the follo= wing special notes:
The _C_HLEVEL_ is alm= ost always 0 in this table.

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

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)

 

=20



------=_Part_8567_581630619.1711708593101--