In the CIA DB2 repository there is a table called ROLEXREF which holds details of connections between users and groups, there are five Role Type values P, U, R, G or F. What do each of the 5 different Role Type values mean?

Document ID : KB000014424
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

In the CIA DB2 repository there is a table called ROLEXREF which holds details of connections between users and groups, there are five Role Type values P, U, R, G or F. What do each of the 5 different Role Type values mean? 

Answer:

In the CIA DB2 repository there is a table called ROLEXREF which holds details of connections between users and groups. The Role Type field indicates the type of role.

Here is the breakdown on the five Role types: 

C'P' is TSS PROFILE
C'U' is UID role
C'R' is Base role of userids
C'G' is Group role of roles
C'F' is RACF group