SQL alteration

From: UXDBA <unixdba73_at_googlemail.com>
Date: Fri, 2 Jul 2010 07:44:54 -0700 (PDT)
Message-ID: <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 Received on Fri Jul 02 2010 - 09:44:54 CDT