- 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) |