Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> FGAC: access sql statement being extended

FGAC: access sql statement being extended

From: robert <gnuoytr_at_rcn.com>
Date: 28 Jun 2004 13:51:57 -0700
Message-ID: <da3c2186.0406281251.5cd762bf@posting.google.com>


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 Received on Mon Jun 28 2004 - 15:51:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US