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:
- Procedure to implement the context
- Database (Oracle8i) level ...