How to setup Data level security based on user login

Jack

HI ,

Can anyone please  help in setting up data level security.

The user who logged in , they should be able to view only data related to them.

I have setup this by adding user in console and assigned role in em.

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

Then again i have added data filter 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.

[Deleted User]

I guess this is a follow-up to Defining security in OBIEE 11g

You never answered Charles' question or updated the thread with regards to whether his input helped or not and what the solution was.

If you do no participate in the community and share information with other users, then it's a bit presumptuous to ask for more help. Exclusively taking and not giving back to the community at all isn't good netiquette. A forum is for sharing and helping. Not for other people to do your work for you that you're getting paid for.

Jack

ok