Oracle-L: RE: Fine Grained Access Control (FGCA)

From: Harrington, Eric <Eric.Harrington_at_maine.gov>
Date: Wed, 05 Mar 2003 14:08:12 -0800
Message-ID: <F001.00561778.20030305140812@fatcity.com>

I too am working with FGAC and agree that documentation is not very helpful! I did download an Oracle whitepaper, it is more high-level but may help - labelsecurity how to.pdf.

I would try to offer some advice, however, my understanding is that each FGAC policy applies to a single object and a single function is associated with each policy. Now you can use this same function for another policy, however, this sounds different than what you are describing below. In my situation, each function will be different because the underlying table structure is different.

Eric

-----Original Message-----
Sent: Wednesday, March 05, 2003 10:06 AM To: Multiple recipients of list ORACLE-L

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! <http://rd.yahoo.com/finance/mailtagline/*http:/taxes.yahoo.com/> Tax Center - forms, calculators, tips, and more

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Harrington, Eric
INET: Eric.Harrington_at_maine.gov

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). Received on Wed Mar 05 2003 - 16:08:12 CST