In addition to what Sylvain posted, each user must use the same ID for connecting to the database.

>The middle tier pooling the connection for all the users is automatic, right? How about if the number of users keep increasing? How would that affect the performance in terms of using just one connection?