Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Column security
> How best & simplest (other than just defining a view for every
> type of column access & creating an infinitely large amount of queries
> around it) could this be accomplished?
Well, if you don't want to do it in the database, do it in your application - i.e., build applications that don't allow the user to see these columns. Short of that - i.e., if users can jump at the database tables via sqlplus, etc - you will have to use views or stored procedures to access these tables and keep the actual tables hidden from the users.
Steve Phelan. Received on Wed Mar 19 1997 - 00:00:00 CST