enabling the admin

[sudheerbattula]

hello guys,
i have some problem the thing is that, while customizing the crm system i have created anew user and i have made that user as a administrator and in the mean while i disabled the default admin, and after that unfortunately i have disabled the admin settings for the new user that i have created, now the situation is like default admin is deactivated and new user dont have the admin authority and now i cant customize the application as the new user is the only user for the system and as he dont have the admin rights i cant customize so guys please help me out for re enabling the default admin such that i can goahead with my work

thanks in advance

[eggsurplus]

Hey sudheerbattula,

To reset the admin as an admin run this query against the Sugar database:

update users
set is_admin = 1
where user_name = 'admin'