I have a legacy table which I cannot change, because hundreds of
modules in my crappy application make direct reference to it in sql
stmts and pro*c stmts. We have new security rules we would like to
implement and which will impact on the number of rows return by
queries on that legacy table. I was thinking of using a trigger for
that task but there is no SELECT triggering event available. So is
there a way to control proceduraly, with PL-SQL, the rows returned by
a table. Some virtual table mecanism ?
Thanks.
Received on Mon Mar 19 2007 - 12:18:18 CDT
