O'Reilly logo

Oracle Database 10g: The Complete Reference by Kevin Loney

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 19Advanced Security—Virtual Private Databases

In prior chapters, you have seen how to use views to enhance security by displaying only the rows that meet specified criteria. In this chapter, you will see how to use a Virtual Private Database (VPD) to provide that type of record-level security across your application tables. In VPD, you attach security policies directly to tables, views, and synonyms so there is no way for users to bypass your security settings.

In a VPD, any SQL used to access a table, view, or synonym protected by a VPD policy is dynamically modified to include a limiting condition—a where clause or an and clause. The modification occurs transparently, and the user sees only the data that passes the limiting condition ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required