CA PPM cmn_sec_groups table details
search cancel

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".

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@