Re: FGAC: access sql statement being extended

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.

--
Sybrand Bakker, Senior Oracle DBA