Re: vpd

  • From: Tim Gorman <tim@xxxxxxxxx>
  • To: smishra_97@xxxxxxxxx
  • Date: Wed, 09 Jan 2008 21:56:27 -0700

Sanjay,

You don't need VPD for that -- just create a view...

        create or replace view tbl_res_contact_v
        as
        select   name, dob, decode(status,'',story,'') story, address
        from    tbl_res_contact;

Then, use permissions to prevent people from querying the table and leave only the view available.

Hope this helps...

-Tim

Sanjay Mishra wrote:
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


Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
-- //www.freelists.org/webpage/oracle-l
  • References:
    • vpd
      • From: Sanjay Mishra

Other related posts:

  • » vpd
  • » Re: vpd