Defining security in OBIEE 11g

Question

HI

In OBIEE 11g, I am trying to setup security for few of people where they should able to see only one particular subject area and catalog related to that.

For This, i have create group and added users to that group using OBIEE console.and create as application role and added group to that role in EM.

Can anyone please suggest as how i can move forward from here in setting security.In RPD, i am not seeing the application role which i created in console.

Jack · Answer

HI CHarles,

Can you help me in setting up data level security.

The user who logged in , they should be able to view only data related to them.I have settup this added user in console and assigned role in em.

Created initialization block when i test it with userinput i am getting only user related data.

Then again i have added data fiter at application roles. But when i logged in i am able to see all the data but i should see ID only of mine but i am able to see all users under iD column.

Charles M · Answer

Hi Manu,

Did you have a chance to review that article/link I provided?

Charles

Jack · Answer

HI,

Both are same version,I Am using OBIA and OBIEE 11.1.1.9.0