Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Column security

Re: Column security

From: Steve Phelan <stevep_at_pmcgettigan.demon.co.uk>
Date: 1997/03/19
Message-ID: <332FA683.1D56@pmcgettigan.demon.co.uk>#1/1

> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US