CA PPM cmn_sec_groups table details

book

Article ID: 185401

calendar_today

Updated On:

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_[email protected], @SELECT:c.name:[email protected],@SELECT:g.LAST_UPDATED_DATE:[email protected], @SELECT:l.ID:[email protected], @SELECT:c.LANGUAGE_CODE:[email protected] FROM cmn_sec_groups g, cmn_captions_nls c ,CMN_LANGUAGES l WHERE @[email protected] 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:[email protected]