Is there a possibilty if getting Resource names who have edit access on a sub page through query?
Thanks and Regards,
you may refer to CMN_SEC_ASSGND_OBJ_PERM_R_V0 filter it by the user internal id
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)
Thanks David, for the inputs.
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_valuefrom 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.
Retrieving data ...