Groups, Access Levels, and InfoObjects

[Former Member]

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.

Thanks.

[atul_chowdhury2 · Accepted solution]

Hi Rene -

You will find the best guidance for addressing this requirement by first:

- Reading through the Business Objects Enterprise JAVA SDK Developer's Guide located at:

http://help.sap.com/businessobject/product_guides/boexir31/en/boesdk_java_dg_12_en.zip

And, specifically, the section titled:

Using the SDK --> User and object security --> Setting Rights --> Object Security Overview

A word of advice: I would try to adhere to using the Java SDK and not the (now unsupported) COM implementation as you will have the fullest degree of flexibility and API exposure using the Java implementation.

Good luck

[Former Member]

I had to write some VBA code in Excel in order to individually check permissions and classify them into my CALs. I know that there is a way to do this by using Java. However, I have never used it before and didn't want to spend too much time learining it. I wish I could help you more.

Thanks.

[Former Member]

Did you get this done? I was trying to get the same info and was successful to some extent. It is not displaying the custom access Levels. Instead it is displaying advanced rights. Please let me know how to get the CAL name instead of Advanced Rights?

Thanks,