Re: Column Level Security under 9i?
Date: 8 Nov 2001 02:56:27 -0800
Message-ID: <aeb3790f.0111080256.72f3ff39_at_posting.google.com>
do not use views, your performance will be very very bad ! use fined grained access control .... or grant it yourself in the database with grant select on column level
Erik
Oracle Dba consultant
Andrew Zitelli <zitelli_at_west.raytheon.com> wrote in message news:<3BE856DE.22D72E6D_at_west.raytheon.com>...
> Can anyone suggest a reasonable way to implement column level security
> in Oracle 9i? The nature of our application makes the use of views very
> difficult because the security requirements may change on the fly and
> will span a fairly large number of users. We need to be able to control
> SELECT access to these columns. It appears that the GRANT statement
> allows one to restrict UPDATES and DELETES by column, but not SELECT.
> Can anyone tell me if there are any other options besides views?
> Thanks!
>
> Andy Zitelli
> zitelli_at_west.raytheon.com
Received on Thu Nov 08 2001 - 11:56:27 CET