Hi All, Leaving the issues of licensing cost etc aside. We are building a CF Oracle application and we are thinking of creating individual Oracle accounts for each user as an added security level. Users will have their usernames/passwords for the site but the actual db usernames/passwords will never be visible to anyone and you won't be able to interact with the db unless you have one. So instead of the usual cf situation where the cfserver connects to the db with only one username/password, this would create a connection for each unique user. From our testing there seems to be a limit of 10 or so concurrent connections before we get an oracle error that indicates that communication is lost between the client and the database server. (We know that there is no problems with Oracle because we can still connect via other tools). We've played arounds with the "maintain database connections" settings in the cf server. If we don't maintain the database connections everything chugs along nicely. If we maintain them for any length of time the concurrent users mount up and the app falls over. Is anyone else out there using individualy identified users for connection to Oracle, if so any tips, war stories or reasons not to would be apprecitated. Craig Harcombe Danaclese ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
