vpd

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Wed, 9 Jan 2008 19:28:21 -0800 (PST)
Message-ID: <950160.61454.qm@web51302.mail.re2.yahoo.com>

Hi

can somebody help in VPD setup. I had a table with 5 column and I want to hide 2 column based on one Column named status. Here is structure

tbl_res_contact
  name varchar,
 dob date,
 status char(1),
 story varchar2(30),
 address varchar2(30)

I want to hide the data for story from all user when status is other than NULL.

TIA
Sanjay

---

Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 09 2008 - 21:28:21 CST