Can Oracle row-level security work with user session credentials?
3
votes
3
answers
1849
views
Can row-level security in Oracle be controlled by a user's session credentials or user context? Here's an example to illustrate what I'm looking for:
Our database contains a bunch of sensitive company information, including salaries. HR administrators should be able to see salaries in their search results, but facilities management staff shouldn't, even if they use the same search parameters. The catch is that our app only has a single database user, and all requests go through it, so the security can't be set up to simply check the database user's ID. We'd have to pass the info in as, say, a user context.
We're considering moving to Oracle Access Manager/WebLogic, if it makes a difference.
Asked by Pops
(133 rep)
Apr 20, 2011, 04:16 PM
Last activity: Mar 12, 2015, 12:35 PM
Last activity: Mar 12, 2015, 12:35 PM