Re: FGAC: access sql statement being extended

Sybrand Bakker <sybrandb_at_hccnet.nl> wrote in message news:<he31e0pemdqp123tpjb8uq6o5da4lic0st_at_4ax.com>...
> On 28 Jun 2004 13:51:57 -0700, gnuoytr_at_rcn.com (robert) wrote:
>
> >my guess is the answer is NO, but is it possible to access the text
> >of the sql statement being modified?
> >
> >what i need to do is, based on the value of (and whether it is
> >used) an equality phrase in the existing WHERE clause, do some
> >security.
> >
> >for example if this is present,
> >
> >... where SomeColumn = 'company' ...
> >
> >then apply security policy. otherwise, let it pass. i know which
> >columns matter, and what values matter.
> >
> >version 8.1.7
> >
> >thanks,
> >robert
>
> Basically this means you want to invent your own FGAC, don't you?
> And you want to 'rewrite' any query yourself?
> I guess there are nicer ways to end up in hell,
> but then I may be not up to your level of willingness to hack myself
> out.

as always a lucid and penetrating transmission

thanks lots,
robert Received on Tue Jun 29 2004 - 07:07:17 CDT