Re: Row level secrity

You may also want to consider the use of views. You can create a view which does a join between the 'data' table and a 'security' table; using the Oracle internal 'user' to drive the security table.  

Here's an example:  

create view employee_uv as
select e.name, e.ssn, e.deptno
  from employee e
 where exists
  (select ''

     from employee_security es
    where es.userid = user
      and es.deptno = e.deptno);  

Hope this helps! Received on Thu Jun 22 1995 - 00:00:00 CEST