Column level security

2003-06-23 Thread Pradeep Kumar G
Dear All, Is there any way to implement column level security in Oracle 9i database ? Information on having row level security through VPD is available. But is it possible to have column level security ? I have seen in some sites,like (http://www.ftt.co.uk/C520_outline.html, http

RE: Column level security

2003-06-23 Thread Naveen Nahata
Views? -Original Message- From: Pradeep Kumar G [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 4:35 PM To: Multiple recipients of list ORACLE-L Subject: Column level security Dear All, Is there any way to implement column level security in Oracle 9i database

Re: Column level security

2003-06-23 Thread rgaffuri
just make a view and dont include the columns. I dont know if there is a VPD for columns. From: Pradeep Kumar G [EMAIL PROTECTED] Date: 2003/06/23 Mon AM 07:04:40 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Column level security Dear All, Is there any

Re: Column level security

2003-06-23 Thread Mladen Gogala
Yup. It's called views. On 2003.06.23 07:04, Pradeep Kumar G wrote: Dear All, Is there any way to implement column level security in Oracle 9i database ? Information on having row level security through VPD is available. But is it possible to have column level security ? I have seen in some sites

Re: Column level security

2003-06-23 Thread Arup Nanda
level security in Oracle 9i database ? Information on having row level security through VPD is available. But is it possible to have column level security ? I have seen in some sites,like (http://www.ftt.co.uk/C520_outline.html, http://www.actisit.com/outlines/forms/Or202_Or9i%20DBA%20I

Re: Column level security

2003-06-23 Thread Jared Still
In addition to views, which have already been mentioned, column level security has been around since at least 7.0. Look at the fine manual under 'GRANT'. Jared On Monday 23 June 2003 04:04, Pradeep Kumar G wrote: Dear All, Is there any way to implement column level security in Oracle 9i

[Q] grant select on column level security failed?

2003-01-29 Thread dist cash
I tried to grant select on column level security and failed (on 8.1.7 and 9.2). I heard some said column level security on work on insert update and reference. Is it true? any other way to pass around? SQL grant select (update_date) on pay_update to user1; grant select (update_date

Re: [Q] grant select on column level security failed?

2003-01-29 Thread Igor Neyman
to grant select on column level security and failed (on 8.1.7 and 9.2). I heard some said column level security on work on insert update and reference. Is it true? any other way to pass around? SQL grant select (update_date) on pay_update to user1; grant select (update_date) on pay_update

column level security

2002-04-23 Thread JOE TESTA
Ok so i've been asked to research column level security, from what I can find, we're still stuck with this: if userA needs to see cols 1,3,5 of tableA and userB needs to see cols 1,2,3,4 of tableA. We're still stuck with doing private views? we dont need row level security so a VPD

RE: column level security

2002-04-23 Thread Khedr, Waleed
that unprivileged user knows table and column names). -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/23/02 10:18 AM Ok so i've been asked to research column level security, from what I can find, we're still stuck with this: if userA needs to see cols 1,3,5 of tableA