Clarity PPM

Expand all | Collapse all

Which table contains the Instance access rights?

  • 1.  Which table contains the Instance access rights?

    Posted 09-22-2015 02:06 AM

    Hi Team,

    Please provide the query to extract the instance access of resource?

    Regards,

    Bala



  • 2.  Re: Which table contains the Instance access rights?

    Posted 09-22-2015 02:17 AM

    Hi

     

    try querying this table : cmn_sec_assgnd_obj_perm

     

    Regards

    Nitin



  • 3.  Re: Which table contains the Instance access rights?

    Posted 09-22-2015 02:22 AM

    Have you checked this. Clarity rights Query

     

    Thanks,

    Ram



  • 4.  Re: Which table contains the Instance access rights?

    Posted 09-22-2015 02:52 AM

    Also, this -

    checking instance rights

    https://communities.ca.com/message/17458630#17458630

     

    NJ



  • 5.  Re: Which table contains the Instance access rights?

    Posted 09-22-2015 02:52 AM

    --Resource Instance Rights

    SELECT DISTINCT a.right_id, g.right_type, g.description description, o.name right_type_name,

    g.group_name right_name, g.group_code, g.is_automatic

    FROM cmn_sec_assgnd_obj_perm a, cmn_sec_groups_v g, odf_objects_v o

    WHERE a.principal_id = 5000108 --resource internal ID

    AND a.principal_type = 'USER'

    AND a.right_id = g.id

    AND g.right_type = o.right_code

    AND g.language_code = 'en'

    AND o.language_code = 'en'

    AND g.is_active=1

    ORDER BY right_name



  • 6.  Re: Which table contains the Instance access rights?

    Posted 09-22-2015 03:42 AM

    instance access of resource

    meaning instance access given directly to the user and not including  instance rights coming from group memberships being associated with and OBS unit or instances rights within an OBS unit.

    There is also a Green book on Security

     

    SAP Portal Services