| Re: Problem with db [message #24 is a reply to message #22] |
Thu, 20 April 2006 15:36   |
AJM
Messages: 2347
Registered: April 2006
Location: Surrey, UK
|
Senior Member |
|
|
I have ever heard of the restriction that you cannot use the same userid/password on more than one database. Indeed, it is common practice to allow just the opposite. You connect to the database server using a single login, and within that connection you can access as many databases (or 'schemas' in PostgreSQL) as you like. You can only supply different login details by making an additional connection, and you cannot perform JOINS across multiple connections.
This idea would also prevent connection pooling where a database connection is not closed, just suspended, so that when a process wants to talk to the database it simply picks up a suspended connection and avoids the overhead of creating a new one.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
