Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

exempt access policy

k_mewesNov 14 2006 — edited Nov 15 2006
Hi all,

I am a little confused by a situation I have here: Among other policies I have a policy for selects and updates on a table in my database. Now I want a specific user to be exempt from the policies by using "grant exempt access policy to USER".
As expected, the user can select manually from the table. But a function executed by that user cannot. For testing, I wrote a small procedure that just returns the result of a select count(*) on that table. When executing the procedure as user, it returns 0 - the select count(*) returns a different number.

Has anybody an idea why this is the case?

Thanks in advance for any suggestion!
Kai.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 13 2006
Added on Nov 14 2006
3 comments
15,451 views