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 se
gt; 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.c
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 ha
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: C
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 c
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
AM
>
> 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> g
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
on tables that are normally not visible (provided 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
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 secur
10 matches
Mail list logo