cmn_sec_groups table had group code with group id, but where can we get the definition of the group_code ?
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".
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@