Database Software

Hi Folks,

hope somebody is able to some hints or suggestions about following question,
as it was posted in a different forum and got only 1 response.
=================================================================
I have a little discussion in our project and as I have no clou about java/jdbc I think and hope this is the correct forum to ask for opinions/suggestions :-)
At a new db I wanted to set strong security privileges to usernames and set in this way the security on db level, so doesn't matter which application is accesing the db, they always have the same privileges.
Now the java/jdbc developer came up that he wants to connect via tomcat with a generic db account and set/define the user privileges in some tables, or at the application server in a file. The reason is that he doesn't want to make as max. 50 connections to the db, because if you use more as 50 connections the hardware resources have to be increased dramaticly and slowdown the hole application.
And as he told this is a standard way todo, I'm just wondering how others solve this and is it a standard?
Because if other applications are accessing the db the security/privileges not working.
Hope somebody can provide a good tip.
==================================================================

Regards, Olaf