Fine Grained Access Control and Application Contexts

Fine Grained Access Control (FGAC) is a technique that allows you to define specific restrictions on database tables (and certain types of operations on these tables) to limit which rows a user can see or change. You can implement it using regular PL/SQL and some database objects, or much more conveniently and securely using the supplied DBMS_RLS package from Oracle. In this chapter, we start with the traditional way of implementing the Fine Grained Access Control and then describe the DBMS_RLS program’s package. We also describe how application contexts work in conjunction with FGAC ...

Get Real World SQL and PL/SQL: Advice from the Experts now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.