View Single Post
  #4 (permalink)  
Old October 2nd, 2007, 19:35
chrisplough's Avatar
chrisplough chrisplough is offline
Site Moderator
 
Join Date: Jun 2006
Location: West Chester, PA
Posts: 821
Blog Entries: 7
Thanks: 53
Thanked 201 Times in 121 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 10
chrisplough has a spectacular aura aboutchrisplough has a spectacular aura aboutchrisplough has a spectacular aura about
Send a message via AIM to chrisplough
Re: ORA-28115:policy with check option violation

Moshe,

I would refer back to your VPD Policies, as the error indicates that you are either trying to change the very column that a table is restricted on, or that you are trying to insert a row that will not satisfy the viewing policy.

This also explains why it works as DBA.ADMIN (i.e. no VPD restrictions) and not as the user that you're logged in as.

Thanks,
Chris
__________________
Chris Plough
MavenWire

www.MavenWire.com
Reply With Quote