nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE 12c security

3482088

Hi guys,

I need some help with OBIEE 12c. I need to get a list of all the users with their respective roles. In the version 11g, i get the system-jazn-data.html file, but in 12c this contains different data.

Could someone help me find an equivalent file? Or some other way to obtain the list of users with their respective roles?

Thanks!!

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

Ok so first of all I pray you didnt actually manage application roles on a user-by-user basis but rather on group level.

Secondly the approach you mentioned CAN only ever work if you manage all role assignments exactly one-by-one for all users. So basically disregarding any inheritance as well.

So there is already a questionable thing there...how IS your security actually set up and managed?

As for "12c" same official was as "11g" actually: WLST. The file isnt something you should have touched manually anyways.

Syedsalmancs110

Refer to below mentioned Blog Post, the script provided in the Blog works fine in Mozilla Firefox browser for both OBIEE 11g and OBIEE 12c to get list of users and assigned Groups/Application Roles.

https://obitechnical.wordpress.com/2015/05/28/obiee-11g-how-to-get-list-of-users-and-their-assigned-groupsroles/

In above Blog post when you are copying the code make sure you copy it from download link named as script as the code mentioned in Blog has issues with double quotes(" ") and single quotes(' ').

[Deleted User]

I'd like to see the faces of the corporate security team when you put that code into the system :-D

Syedsalmancs110

Did Intend to add that i.e. not to keep the code in system,but forgot to add the same in previous update, though was to just get the required information as from the post it looked like it was a one time activity in order to maintain the User-Group-Role mapping data.

3482088

Hi Syed,

Thanks for the answer, but I tried with this method, and this not work in 12c.

You know other method? thanks you.

[Deleted User]

WLST or WebServices

Just with a proper wrapping and not analyis-based JS with passwords in clear text stored in a dashboard artefact and ActiveX etc etc

3482088

Thanks for the answers! I already found the file with the information of all the users with the associated roles. Thank you very much to all.

Regards,

Javier.