BusinessObjects Query builder

[#1]

List all the Public folders(including Subfolders) and which UserGroups has access to those folders/subfolders.

In CMC->Folders-> [choose folder] ->User Security-> [choose UserGroup] ->View Security. This provides the Principal and Objects(Folder) to which the access is enabled. Can you assist to obtain this information in Query Builder? Thanks.

[TJe]

You may be able to used the CMS DB universe CMS Data Access Driver instead. You can query the Principal Name, Principal Kind and Access Level with Universe Objects provided in Folder InfoObjects - Security.

Please review the answer posted here: Query all folders security in BO