SQL user for multiple SQL connections via users logging in

Please bear with me. I am quite new to Vaadin.

I managed to create connect to my SQL DB using the SimpleJDBCConnectionPool. I created a simple SQL user (with access to the DB tables) for the JDBC to connect within my app.

Now I have a new app which has multiple users access with simple login. My question is, do I have to create a new dedicated SQL user to connect for each of the app’s user or I can use the same SQL user for multiple connections (due to users login simulatenously)?

Hi,

you should be able to use the same database user for multiple users of the Vaadin application, assuming that this is ok for your application. In some cases you might want to restrict database privileges on a per-user level, so in that case you need more database users and select the correct one by the logged in user.

-tepi