Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 12c security

Received Response
1
Views
7
Comments
3482088
3482088 Rank 1 - Community Starter
edited Aug 13, 2024 6:00PM in Oracle Analytics Cloud and Server

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!!

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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
    Syedsalmancs110 Rank 6 - Analytics Lead

    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]
    [Deleted User] Rank 2 - Community Beginner

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

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    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
    3482088 Rank 1 - Community Starter

    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]
    [Deleted User] Rank 2 - Community Beginner

    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
    3482088 Rank 1 - Community Starter

    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.