General OBIEE

Get Involved. Join the Conversation.

Topic

    Aaron Leggett
    Security Console TablesAnswered
    Topic posted July 20, 2017 by Aaron LeggettSilver Trophy: 7,500+ Points, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Data Models, Fusion, OBI Answers, OBIEE Answers, Report Output, Setup/Administration, SQL 
    228 Views, 5 Comments
    Title:
    Security Console Tables
    Content:

    Hi Everyone 

     

    Quick question, is there a table that I can query in BIP that will show me the Roles and Roles Description? We have been struggling to assign the right roles to the right people throughout our implementation and I feel this report will give us a much better understanding for our programme team to see what each role gives access too. Below is a screenshot from the Security Console showing what I would like to extract (Role Name, Role Code and Role Description...if possible the type of role too, such as Duty, Data etc.). 

     

    Image:

    Best Comment

    Rachel Martorelli

    Hello Aaron,
      I'd suggest running the following jobs to get the data you are looking for:

    User Role Membership Report
    User and Role Access Audit Report

    Comment

     

    • Rachel Martorelli

      Hello Aaron,
        I'd suggest running the following jobs to get the data you are looking for:

      User Role Membership Report
      User and Role Access Audit Report

      • Prudence Kruchten

        Rachel - where would I find these reports?  I did a search and cannot find anything.  Maybe I am not in the right spot?

        • Sasmita Babu

          Hi,

           

          Please Go to Navigator > Schedule Processes > search for the process,if you still not able to see than attach IT_SECURITY _Manager role to your user.

          and then give it a try.

      • Aaron Leggett

        Hi Rachel

        Thank you so much, we have managed to get the information we needed! 

    • Karthik Vinodkumar

      Hi Rachel,

      I am trying to pull role category into BIP report. But i am not able to find any table which stores this information. Can you please help me in finding out this table name.

      Thanks,

      Karthik