Skip to Main Content

Oracle Database Discussions

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!

Question concerning the INSERT statement when using VPD

User_PUQNBMay 8 2011 — edited May 10 2011
Hello, I want to use VPD to control the access of data. As I learned, VPD supports INSERT statement, but I'm curious how it works. For SELECT, UPDATE and DELETE statements, VPD applied predicates to the query. But INSERT statement can't use where clause (predicate).

I searched the forum and web, couldn't find any explanation or documentation. Please help. Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 7 2011
Added on May 8 2011
6 comments
325 views