Re: SQL alteration
Date: Fri, 2 Jul 2010 18:20:22 +0200
Message-ID: <4c2e11c7$0$17254$426a74cc_at_news.free.fr>
"UXDBA" <unixdba73_at_googlemail.com> a écrit dans le message de news:
5edf20cb-dc15-48f0-b44c-92f95fb7012a_at_u8g2000vbh.googlegroups.com...
| All,
| Just one questions. ( I know Oracle is not written this way... but
| wanted to see the thread users response/comments )
|
| Session #1 from client 1 :
| --------------------------------------
|
| issues the following:
|
| select * from T;
|
| Is there any way this SQL can be intercepted in backend and a filter
| is added to this query.
| something like....
|
| where 1=2
|
| i.e. Actual sql processed would be
|
| select * from T where 1=2;
|
| So that no rows are retruned to the user who has issued the above sql.
| (mainly wanted to add a predicate which is FALSE hence no results set
| is returned.)
|
| Thanks
|
Have a look at VPD and DBMS_RLS package.
Regards
Michel
Received on Fri Jul 02 2010 - 11:20:22 CDT