I want to get the list of folders, groups, users and their privileges on the folder. Query has been built using opb_object_access,opb_subject and opb_user_group tables to get the folders, Group and privileges on the folder (Query returns the Groups privileges on folders)
How to get the user level access details on folder? We are getting user list from LDAP.
Hi Saravanakumar ,
Please refer the below thread for getting the user access for the respetive folder.
I've already used that query, however its showing only group information. I tried lot of table but could not able to get this list.
Table opb_object_access has only access permissions of group level.
You will find following free tool on Informatica Marketplace Website useful. It can give you most of the information that you would like to have from Informatica Repository.
You will also find over 100 mapping samples and many other useful tools on the same website.