exempt access policy
k_mewesNov 14 2006 — edited Nov 15 2006Hi 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.