Hi Madhavan
Thanks for the response. I did get it working. However I have another question. Have you tried to capture what happens behind the scene. I turned on trace however could not trace the actual query that gets added to the SQL statement. Only the function call could be traced not the actual SQL condition
Thanks
Menon
Madhavan Amruthur <[EMAIL PROTECTED]> wrote:
Hi Murali,
We have FGAC working on any number of tables and the policy is applied by
a single function and the text generated is picked up from a table and we
have it working without any problems.
If you can post details of what you are trying to do we can try and
identify why the policy is not being applied to the second table or the
reason for the 0 rows.
We have a function that generates the text that will be applied as the
where clause depending on the object being accessed.
When the policy is applied it invokes this function and then applies the
predicate based on the text returned from the function
Please let me know if you need more detailed information
Thanks
Madhavan
http://www.dpapps.com
On Wed, 05 Mar 2003 07:05:37 -0800, "Murali Menon" <[EMAIL PROTECTED]>
said:
>
> Hi Guys,
>
> I am trying t! o setup FGCA for our customers on their reporting system. I
> have got this working for a single table, however, when a policy needs to
> be added for multiple tables. It fails returning no rows from the second
> table.
>
> Oracle documentation is not very helpful this arena. Can anyone provide
> any pointers to white papers or documents on this subject.
>
> Thanks
>
> Menon
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Tax Center - forms, calculators, tips, and more
--
Madhavan Amruthur
DecisionPoint Applications
--
http://www.fastmail.fm - Access all of your messages and folders
wherever you are
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Madhavan Amruthur
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mai! ling list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, and more
