1 Reply Latest reply: Jan 16, 2013 3:20 AM by Voltaire RSS

    OBIEE security

    sarvan
      Experts,

      We have a dashboard that has 2 pages - Supervisor and Employee. Note, supervisor ID and Employee ID is a drop-down in supervisor and Employee tab respectively.
      Now, we want to implement security for these pages. Here is the requirement.

      1) If a Global user logs in, he should be able to see both the tabs and also he should be allowed to pick any value from the supervisor ID dropdown of supervisor tab and Employee ID dropdown of employee tab
      2) If a supervior logs in, he should be alble to see only his reports in supervisor tab (Supervisor ID must take the User session variable value and run) and on the employee page, he will be able to see employee working under him in the drop down
      3) If a employee logs in, he should be able to see only Employee tab and the report has to run for his login ID by taking the USER session variable (similar to supervisor)

      Env - OBIEE 10g

      Regards,
      Sarvan
        • 1. Re: OBIEE security
          Voltaire
          Hi Sravan,

          Basically you are trying to set row-level security for data and object level security for tabs. The below links should help you:

          Row-Level/Data security: http://www.rittmanmead.com/2007/05/obiee-and-row-level-security/
          Object Level Security: Once you have the groups created as above remove access to dash boards.

          Let me know if this worked.

          Regards,
          Jay