Column Level Security under 9i?

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 Tue Nov 06 2001 - 22:32:14 CET