Images

CHAPTER16

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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.