How to get folder access rights information using BI platform CMS system database universe

[fmozas]

Hi,

I'm using the new CMS data access driver for BI 4.2 to query the metadata of the CMS repository database.I'm trying to create a webi report with all the existing groups in the BO system and index the folders which the group grants access.

I have tried to use the information provided by the Technical properties but I can't find which one indicates access to a report of a user or group.

Any idea?
Thanks in advance!

[TJe · Accepted solution]

Here is an answer from the wiki: Unlock the CMS database with new data access driver for BI 4.2

Hi, all what you can do is to create a query that extract the security defined on any object (webi, folder, universe, etc...) as you can see defined on "user security" tab on CMC. The dimensions that extract these information are: PrincipalName and Access under "Infoobjects-Security" folder. "PrincipalName" retrieves the name of the user or of the usergroup and "Access" retrieves the ACL or specified right granted to that user or usergroup.

hope this helps, regards Thomas

[fmozas · Accepted solution]

I have managed to create the webi report I needed with the CMC data.

Thank you very much for the information Thomas!

Regards.