We have migrated to a different LDAP Authentication for SugarCRM. Due to this existing Admins cannot login. Can a new user be made an Admin via updating the users table in the DB, column is_admin = 1 ?
Hello,
Yes, the 'is_admin' column is used to indicate whether a User is or is not a 'System Administrator' type User.
I would recommend using this query as a guide, to ensure that only the specified User is updated as required:
UPDATE users SET is_admin=1 WHERE user_name='{Username}' AND status='Active';
Regards,
Dan Kallish
Advanced Support Engineer
SUGARCRM
Learning Resources: http://support.sugarcrm.com | http://university.sugarcrm.com | http://community.sugarcrm.com
Hello,
Yes, the 'is_admin' column is used to indicate whether a User is or is not a 'System Administrator' type User.
I would recommend using this query as a guide, to ensure that only the specified User is updated as required:
Regards,
Dan Kallish
Advanced Support Engineer
SUGARCRM
Learning Resources: http://support.sugarcrm.com | http://university.sugarcrm.com | http://community.sugarcrm.com