I have different databases for each country.
however the Report is all same.
how do I create dynamic connection pool based on the Role/User.
Use Session Variables for DSN and User. There are lot of links in google to explain you better. I dont have access here to provide you the links.