This content has been marked as final. Show 3 replies
I'm don't think there is a Java API for this. (I could be wrong)
This can be achieved using SQLs
1 & 2 can be achieved using the below SQL (run this as biplus repository user)
3 can be achieved using the below SQL
select c.name as "User Name", d.name as "File Name" from v8_access_ctrl a, v8_container d, v8_css_user b, hssdbuser.css_users c where d.container_uuid = a.resource_id and b.subject_id=a.accessor_id and c.identity_id=b.css_identity and d.name='your report name/folder name';
select a.name, b.fr_path from v8_container a, (select v8_container.name , parent_folder_uuid, container_uuid, connect_by_isleaf "isleaf", sys_connect_by_path(v8_container.name,'/') as fr_path from v8_container where meta_type_uuid = 'id03' connect by prior container_uuid=parent_folder_uuid start with container_uuid ='reportmart' ) b where a.parent_folder_uuid = b.container_uuid and b.fr_path like '%/your folder name' order by a.meta_type_uuid asc, fr_path asc
Yes, there are APIs for doing what you are interested in. It is adviseable to use API instead of Direct SQL Query against repository tables as they can change from version to version.
I recommend you look at the documentation
Oracle Hyperion Reporting and Analysis - Framework Developer's Guide
You may also need to look at
Oracle Hyperion Shared Services - Security API Reference
Can you please let me know which API can provide that information.
I tried FetchCategory.java and ObjectByPath.java, however none of them give any information about their access. (that's why i went the SQL route)