Admin Rights Changed by mistake...

[renjith.vs]

Hi Guys..

I made a mistake right now.. In the Settings/System/Staffs/editgroup1/.. it was Admin account.. By mistake I changed to staff account from the list and now I don't have access to Settings..!! 

 

Pls someone help me to restore it back..

[Jono]

This query should do the trick:

UPDATE acl_acl INNER JOIN acl_aco ON acl_aco.id = acl_acl.aco_id SET acl_acl.permission = 'allow' WHERE acl_aco.alias = 'admin_system_staff' AND acl_acl.action = 'editgroup' AND acl_acl.aro_id = 1;

Then you can visit admin/settings/system/staff/editgroup/1/ to make sure all appropriate permissions are enabled.