Re: FGAC: access sql statement being extended

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

try playing about with v$open_cursor...but it sounds expensive to do this with lots of users/queries

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------