User showing up under Manager License in the License Portlet but the user access rights has none of the Manager rights in it.

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

The License Information portlet at the administration side of CA PPM is not only dependent on the user access rights (Instance, OBS, Global), but is also dependent on the object specific access rights granted to the user.

For example, the user might have only Team member access rights in Instance, OBS and Global but may still show up as Manager License and one of many reasons for this behaviour is, the user was part of a Project Participant page and was the collaboration manager for that project. Collaboration Manager rights will not show up in the user access rights page.

Answer:

The below query can be used to find the list of Collaboration managers against the respective investments.

SELECT CMN_SEC_USER_GROUPS.ID
      ,CMN_SEC_USER_GROUPS.USER_ID
      ,CMN_SEC_USER_GROUPS.GROUP_ID,
CMN_SEC_USERS.LAST_NAME
,CMN_SEC_USERS.FIRST_NAME
,CMN_SEC_USERS.USER_NAME
,CMN_SEC_GROUPS.GROUP_CODE
,INV_INVESTMENTS.NAME
,INV_INVESTMENTS.CODE
,INV_INVESTMENTS.ODF_OBJECT_CODE
  FROM
CMN_SEC_USER_GROUPS
,CMN_SEC_GROUPS
,CMN_SEC_USERS
,INV_INVESTMENTS
WHERE
CMN_SEC_USER_GROUPS.GROUP_ID = CMN_SEC_GROUPS.ID
and  CMN_SEC_USERS.ID = CMN_SEC_USER_GROUPS.USER_ID
and CMN_SEC_GROUPS.GROUP_CODE LIKE 'CLB_PROJECT_MANAGERS%'
and  INV_INVESTMENTS.ID = substr(CMN_SEC_GROUPS.GROUP_CODE,-7,7)
and CMN_SEC_USERS.USER_NAME ='ABCDE'

--The user name at the bottom of the query will have to be replaced with the user in question or comment the last line to get the complete list of resources who are part of collaboration manager group.