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
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