Skip to Content
Former Member
Mar 15, 2010 at 09:25 PM

Groups, Access Levels, and InfoObjects


Hello All,

I am trying to get a list of all the users, access levels, and objects they have access to. However, I cannot find a way to get the custom access level which a user group has over a folder/universe on the repository. The only info I could find is Role, but it gives only default access levels: full, view, view on demand, advanced, etc.

The layout of the report would be something like this: Universe Name, Group(s) that have access, Custom Access Level. for instance:

Universe 1, Administrators, Full Access

Universe 1, Marketing, Content - Developer (this is a CAL)

Universe 1, Finance, Content - Standard (this is a CAL)

Is there any specific query(ies) that I can use to get this information? I have found examples for XIR2 that do not apply 100% to XIR3 as CALs were introduced on this version only.

My environment: BOE 3.1, Apache Tomcat, Java Infoview, SQL Server 2005, Windows 2003. I am using Excel and VBA to get this information.

Any guidance would be much appreciated.