How to setup Data level security based on user login — Oracle Analytics

Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to setup Data level security based on user login

Received Response
11
Views
2
Comments

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.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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
    Jack Rank 4 - Community Specialist

    ok