Chapter 52

Managing Row-Level Security in Oracle8i

Michael R. Ault

New to Oracle8i is the concept of row-level access restriction. For years DBAs have requested some form of conditional grant where access to specific rows can be easily restricted or granted, based on user or group membership. Oracle has finally given DBAs the functionality of conditional grants in the form of row-level security.

Row-level security is managed using a combination of Oracle8i contexts, stored procedures, database level triggers, and the DBMS_RLS package. The entire row-level security concept is tightly bound to the concept of a database policy. Generally speaking, a policy will require a:

  1. Context
  2. Procedure to implement the context
  3. Database (Oracle8i) level ...

Get Oracle Internals now with O’Reilly online learning.

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