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
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
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
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
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
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
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
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
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
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
10 matches
Mail list logo