> Each application has its own database.

Use ROLEs.

All user can connect to all databases but when unentitled user connected
one, he can't do or see anything.

eMeL