Hide sensitive data with Oracle 10g column masking

Friday Feb 9th 2007 by DatabaseJournal.com Staff

Oracle 10g's Virtual Private Database (VPD) feature has the ability to automatically mask out (set to NULL) certain columns in the results of a query on a row-by-row basis. This tip shows how to create a VPD policy that requests the column masking option.

[From Builder.com]

Oracle's Virtual Private Database (VPD) feature (also called Fine Grained Access Control) provides row-level security checking for DML statements such as SELECT. A PL/SQL policy function is associated with a table; the function can examine the current user context and return additional WHERE clause conditions (predicates) to be added to the query.

The article continues at http://builder.com.com/5100-6388_14-6156626.html?tag=sc

Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved