CA PPM cmn_sec_groups table details

Products

• Clarity PPM SaaS

Issue/Introduction

 

1. cmn_sec_groups table had group code with group id, but where can we get the definition of the group_code ?

2. How can we map the group with access rights? For example group_code "baseUserGroup" is mapped to access right  "Projects - Navigate, Organizer - Access, Audit Trail - View - All, Account Settings - Navigate".

 

Environment

Release : 15.6.1

Component : CA PPM SAAS APPLICATION

Resolution

 Lookup CHECK_SYS_GROUPS_BROWSE  

Query:

 

 

 

 

 

SELECT @SELECT:g.group_code:group_code@, @SELECT:c.name:group_name@,@SELECT:g.LAST_UPDATED_DATE:LAST_UPDATED_DATE@, @SELECT:l.ID:LANGUAGE_ID@, @SELECT:c.LANGUAGE_CODE:LANGUAGE_CODE@ FROM cmn_sec_groups g, cmn_captions_nls c ,CMN_LANGUAGES l WHERE @FILTER@ AND g.is_active = 1 AND g.group_role_type = 'GROUP' AND g.group_code not like 'CLB%' and c.table_name = 'CMN_SEC_GROUPS' and c.pk_id = g.id and c.LANGUAGE_CODE = l.LANGUAGE_CODE and c.language_code = @WHERE:PARAM:LANGUAGE@