O'Reilly logo

Oracle Database 12c Security by William Maroulis, David Knox, Scott Gaetjen

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

images

CHAPTER9

Access Controls with Oracle Label Security

Oracle Label Security (OLS) controls row-level access to data in a protected table. The foundation of OLS is Virtual Private Database (VPD), implemented using the row-level security package DBMS_RLS. OLS is another example of table fire with row filter (TFRF) as we saw with VPD in Chapter 7 and RAS in Chapter 4.

About Oracle Label Security

OLS is uniquely different from VPD and RAS because OLS offers a declarative policy with constructs for its components. OLS does not require the deep technical programming know-how that RAS and VPD require. Also, VPD, RAS, and OLS can be used as separate security ...

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