How to get applied permissions to a Folder in OBIEE 11g

Question

Hi Team,

I need to capture the Permission type, Application roles and who has permissions to that particular folder in OBIEE 11g. I have to prepare a report on this.Can you please help me here.

Thanks in Advance!

SK

Sa12345 · Answer

Hi Emmanuel,

Thank you very much for your detailed Explanation!

-SK

EmmanuelMash · Answer

Hi Shiva

The codes and meanings are as follows:

* N - No Access
* R - Read
* X - Execute (Also used to traverse)
* W - Write
* D - Delete
* P Change Permissions
* O - Set Ownership
* L - Run BIP
* S - Schedule Report
* V - View Publisher
* F - Full Control

As per your report above the following users have the

* DMcGrath=Read + Execute
* adinson=Read + Execute
* young=Read + Execute
* obieeadmin = Full Control etc

Regards

Emmanuel

Sa12345 · Answer

Thanks for your help on this.

When i select the above mentioned columns from Catalog Manager, I'm getting the ACL column values as follow.

DMcGrath=RX:adinson=RX:young=RX:obieeadmin=F:charpentier=RX:russo=RX:wireman=RX:daniel=RX:Radford=RX:sharmam=RX:weblogic=F:^AP Portal Access=RX:

Could you please suggest me?

Thanks,

SK