File/Folder privileges
Options
<p>Hi, we are in the process of migrating our reports from iHub2 to iHub3 manually.</p>
<p>Is there a way to check the file/folder permissions on the backend(postgresql) or any other way?</p>
<p>I had a look at some tables in postgresql(for example below query and output) but it did not help me as file_privilges are in number format. It is not showing if a file/folder has read or write or any other privilege.</p>
<p>Instead it is displaying some number.</p>
<p> </p>
<p>select file_name,file_type,file_privileges from ac_chi_prd1_birt_01.ac_file_or_folder ff, ac_chi_prd1_birt_01.ac_file_privileges fp<br>
where ff.file_iid = fp.file_iid</p>
<p> </p>
<p>"Heller Group.rptdesign";"RPTDESIGN";-32737<br>
"IO Designs";"DIRECTORY";21<br>
"Heller Group.rptdesign";"RPTDESIGN";-32705</p>
<p>Is there a way to check the file/folder permissions on the backend(postgresql) or any other way?</p>
<p>I had a look at some tables in postgresql(for example below query and output) but it did not help me as file_privilges are in number format. It is not showing if a file/folder has read or write or any other privilege.</p>
<p>Instead it is displaying some number.</p>
<p> </p>
<p>select file_name,file_type,file_privileges from ac_chi_prd1_birt_01.ac_file_or_folder ff, ac_chi_prd1_birt_01.ac_file_privileges fp<br>
where ff.file_iid = fp.file_iid</p>
<p> </p>
<p>"Heller Group.rptdesign";"RPTDESIGN";-32737<br>
"IO Designs";"DIRECTORY";21<br>
"Heller Group.rptdesign";"RPTDESIGN";-32705</p>
0
Comments
-
<p>Hi Sriram4133,</p>
<p> </p>
<p>While you could look at designing a query for postgresql (you'll need likely a more complex query than the one presented), you may also find that using our IDAPI provides a better custom solution for your request. The IDAPI can be used to traverse your system and provide details like privileges, etc.</p>
<p> </p>
<p>Postgresql query information: <a data-ipb='nomediaparse' href='http://www.postgresql.org/docs/8.2/static/queries.html'>http://www.postgresql.org/docs/8.2/static/queries.html</a></p>
<p> </p>
<p>Information regarding IDAPI for iHub2 can be found here: <a data-ipb='nomediaparse' href='http://developer.actuate.com/be/documentation/ihub2/mc/help/wwhelp/wwhimpl/js/html/wwhelp.htm#href=serverapi/about-USIT.html'>http://developer.actuate.com/be/documentation/ihub2/mc/help/wwhelp/wwhimpl/js/html/wwhelp.htm#href=serverapi/about-USIT.html</a></p>
<p> </p>
<p>Information regarding IDAPI for iHub3 can be found here: <a data-ipb='nomediaparse' href='http://developer.actuate.com/resources/documentation/ihub31/integration/'>http://developer.actuate.com/resources/documentation/ihub31/integration/</a></p>
<p> </p>
<p>Please note: IDAPI is a customization and may take some time to learn and apply. I does provide a greater level of implementation and has been used to great success among other members of the community.</p>
Warning No formatter is installed for the format ipb0 -
<p>Thanks Jeffrey for your quick reply and the information you provided.</p>
<p>I will try to write a more complex postgresql query.</p>
0
Categories
- All Categories
- 108 Developer Announcements
- 53 Articles
- 106 General Questions
- 145 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 900 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 120 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
