/
PM_ROLE_REQUIREMENT Table

PM_ROLE_REQUIREMENT Table

Sep 04, 2018

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