connect database according to user

**nanduruchi** · 2012-01-21, 05:10 AM

Hi All,
I am nandkishore and i have user sugarcrm 5.2 and 5.3 version.i have want connect user wise database.
,means suoppose two user i have create in the mysql 1.root1 and root2

if i have login with admin user in the sugarcrm so it use root1 user for connect database.
and when i have login with other user so it connect root2 user .
so it is possible in the sugarcrm or not.if i have do this,what can i do.

Thanks in advance.

**andopes** · 2012-01-23, 10:24 AM

What is the goal of such requirement?

Regards

**gauts** · 2012-01-23, 12:39 PM

Maybe you can use config_override.php to check user and change config.
Check first if user info ares avalaible when this file is required.

But you shouldn t need to do this manipulation : acl roles must be enough for your security

**rafael.q.g@hotmail.com** · 2012-01-23, 01:47 PM

Normally is used just on database user per web application, it is the most recomended by security policies.
As suggested you could try to use roles or teams (in case on sugar PRO) to define your security restrictions.