Re: SQL alteration

From: UXDBA <unixdba73_at_googlemail.com>
Date: Fri, 2 Jul 2010 09:52:32 -0700 (PDT)
Message-ID: <58fd99e5-9a1e-442b-8e66-e9497cc2c4c5_at_a40g2000vbl.googlegroups.com>

On Jul 2, 5:21 pm, ddf <orat..._at_msn.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

no . single user issues multiple requests and if the quoted SQL is issued. we wanted to restrict that SQL alone. Received on Fri Jul 02 2010 - 11:52:32 CDT