Clarity

  • 1.  Resource names who have edit access on a sub page

    Posted Aug 09, 2017 10:48 AM

    Hello All,

     

    Is there a possibilty if getting Resource names who have edit access on a sub page through query?

     

    Thanks and Regards,

    Sai.



  • 2.  Re: Resource names who have edit access on a sub page

    Posted Aug 09, 2017 12:37 PM

    Hi Sai,

     

    you may refer to CMN_SEC_ASSGND_OBJ_PERM_R_V0 filter it by the user internal id

     

    Regards,

    Samik



  • 3.  Re: Resource names who have edit access on a sub page

    Posted Aug 09, 2017 12:37 PM

    Yes but its probably much easier just to look in the application since there are a number of ways a resource could get access to the subpage depending on how the subpage is secured (access rights vs display conditions) and how you assign security rights in your particular system.

     

    (i.e. it might be a complicated query - there is some discussion of how queries to determine rights can get complicated here Clarity rights Query  but that is a more general discussion rather than one limited to subpage access)



  • 4.  Re: Resource names who have edit access on a sub page

    Posted Aug 10, 2017 12:26 PM

    Thanks David, for the inputs.

     

    Dear Sai,

     

    As David mentioned it is possible to get the information based upon secured subpages / security model

    Following is an example of how you can get the resource name, who may have a specific access on the sub page, from database, which I guess you are looking for.

     

    Consider the following sub page created on a Project object and is accordingly secured.

     

    Accordingly the following access rights are created in the system, respectively for View and Edit permissions:

    Lets say the above access rights were granted to me. My user_id (column on srm_resources) = 5007002. If the following query is executed:

     

    Select
    (select full_name from srm_resources where user_id = per.user_id) Resource_name,
    per.permission_code,
    per.permission_value
    from CMN_SEC_ASSGND_OBJ_PERM_R_V0 per where per.user_id = 5007002

     

    The above sub page access rights will be listed , along with the other general page access rights which this user has:

     

    You can further correlate on Permission Code , by linking tables like CMN_SEC_OBJ_TYPE_PERM, CMN_SEC_PERMISSIONS

     

    Hope this helps.

     

    Regards,

    Samik



  • 5.  Re: Resource names who have edit access on a sub page

    Posted Aug 10, 2017 01:37 PM

    thanks