Column Level Security under 9i?
From: Andrew Zitelli <zitelli_at_west.raytheon.com>
Date: Tue, 06 Nov 2001 13:32:14 -0800
Message-ID: <3BE856DE.22D72E6D_at_west.raytheon.com>
Date: Tue, 06 Nov 2001 13:32:14 -0800
Message-ID: <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