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