Server (Cells) Design
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata
  • In order to assign the permissions to edit the PM tables, entries are made into the PM_ROLE_REQUIREMENT table as shown below.
  • There is a column to record "read" and a column to record "write" permissions.
  • The MANAGER permission is only allowed in tables that have a PROJECT_ID or a PROJECT_PATH.
  • Each table name and column name are specified in the table.
  • An @ in the TABLE_CD or the COLUMN_CD columns for a specific code is similar to a wild card character and implies that the code can be used in any column with a similar name in any table or any column in the table.
  • NAME_CHAR can be used as a description for the purpose and function of a column (varchar datatype for lookup / searching capabilities).



PM_ROLE_REQUIREMENT

 

 

PK

TABLE_CD

varchar(50)

PK

COLUMN_CD

varchar(50)

PK

READ_HIVEMGMT_CD

varchar(50)

PK

WRITE_HIVEMGMT_CD

varchar(255)

 

NAME_CHAR

varchar(2000)



  • No labels