2011年3月15日星期二

VPD in Oracle

VPD is a very useful feature in Oracle 10g?
SQL Code to set and get the VPD is as below:
dbms_session.set_context('CLIENTCONTEXT','entity_code',to_char(your_cod_entity));

sys_context('CLIENTCONTEXT','entity_code');

A more comprehensive description of VPD will be recorded later.