Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: masking column values
On a totaly different line of thinking,
what if the tables where masked with a view that did the filtering or
rows.
For example, say that you want to limit access to the employees table
data.
You could create a view something like ...
Create view restrict_emp as
Select name, salary, hiredate
from employees, v$session
where name = username
and audsid = userenv('SESSIONID');
You could then play with the complexity, by using a union on the
opposite predicate...
You could then display blanks or different values in either part of
union/select.
This approach would also let the user add their own condition to your
view definition.
Received on Fri Feb 11 2005 - 14:54:27 CST