When administering our Oracle Portal 10g, we are using groups to define who has Manage access to a given page. Is there any way to list what pages a particular group has Manage access to?
Thanks for any assistance!
The table portal.wwsec_sys_priv$ contains the information on what components, items, pages, etc. a group has privileges to. The following URL will give you an example of a query someone posted years ago which might get you started. report on group & user access in portal
Oportalist, thank you very much for that - it was very helpful. When our team ran that query, we got out data like:
- group name
- page name
- access role
- an LDAP identifier such as "cn=departmentname,cn=portal.080610.123111.961450000,cn=groups,dc=business,dc=com,dc=au".
Is there any way to get the actual URL to the pages being queried? The page name by itself isn't always enough context for me to work out what specific page the record is for.
Thanks again for your assistance!