Re: SQL alteration

From: ddf <oratune_at_msn.com>
Date: Fri, 2 Jul 2010 09:21:46 -0700 (PDT)
Message-ID: <0f9692f2-26c3-49f8-aeb5-f5c92aed8371_at_x24g2000pro.googlegroups.com>



On Jul 2, 10:44 am, UXDBA <unixdb..._at_googlemail.com> wrote:
> 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

Is there a particular user you're wanting to restrict with this?

David Fitzjarrell Received on Fri Jul 02 2010 - 11:21:46 CDT

Original text of this message