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 to 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 -- Mailing 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).
