5 Replies Latest reply on Apr 24, 2017 9:08 AM by Gianni Ceresa

    How to reverse engineer user-role mapping in OBIEE 11g to OBIEE 12C

    Srinaath Kathirvelu Saroja-Oracle

      How to reverse engineer user-role mapping in OBIEE 11g to OBIEE 12C

       


      Fresh OBIEE 12c installation
      Migrated  wls-users from existing OBIEE 11g Production to new OBIEE 12c Production
      Migrated RPD & Webcat from existsing OBIEE 11g Test to new OBIEE 12c Production

      Then we have everything execpt to user-role mapping.
      Since we have about 25 roles and 75 users we would like have  an easy path to get that from existing OBIEE 11g Production to new OBIEE 12c Production

      Using the 11g GUI we can only examine one role at the time and display to users belonging to it in a 4 row windows on that page.

      That makes it unusable to reverse engineer the current user-role mapping.

      Is there a tool for that?
      Or in which table(s) is that information present?
      Or in which files is that information present?

      Your feedback is much appreciated.

      Thanks in advance,
      Regards,
      Srinaath KS