Re: Fine Grained Access Control (FGCA)

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 <mad5698_at_fastmail.fm> 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" 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: mad5698_at_fastmail.fm

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: ListGuru_at_fatcity.com (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
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Murali Menon
  INET: mjgnmenon_at_yahoo.com

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: ListGuru_at_fatcity.com (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).