RE: Fine Grained Access Control

Todd - Haven't used fine grained access control yet, but out of curiosity, how would this work with Weblogic connection pooling? Are you assigning each user an Oracle username? Does that mean you are using a dedicated connection and no pooling?

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, October 25, 2002 9:04 AM
To: Multiple recipients of list ORACLE-L

Hey Guys,  

I used FGAC for a small application a year ago without problems/issues. I have reread the docs and now I would like to know the experiences of those using FGAC for larger systems.  

I am now working on an OLTP system that will have tables in the 4+ million range with 100+ concurrent users. It is 8.1.7.4 on HPUX 11 with WebLogic 7. Are there any performance issues with using FGAC in this configuration and with this amount of data? Is there anything I should avoid other than the obvious?  

Thanks,

Todd Carlson

Oracle Database Administrator

Tripos, Inc.

(314) 647-8837 Ext.3246
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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).