Forums / Install & configuration / How to assign admin to the admin role once you've unassigned it ?

How to assign admin to the admin role once you've unassigned it ?

Author Message

Xavier Dutoit

Monday 17 March 2003 1:23:46 pm

Dear all,

I was toying with the rather complicated role/group/user permission system.

I had the stupid to unassign the admin user from the administrator group.
Therefore, the admin can't administer the users anymore, and thus can't give him the admin rights back.

I have an access to the database. How can I give back the administrator rights to the admin user ?

Thanks in advance

X+

P.S. I'd rather avoid to reinstall the system ;(

http://www.sydesy.com

Sergiy Pushchin

Wednesday 19 March 2003 2:47:21 am

insert into ezuser_role ( role_id, contentobject_id ) values(2,12);
it will assign admin role to all users under administrator user group. To assign admin role dirrectly to admin user:
insert into ezuser_role ( role_id, contentobject_id ) values(2,14);

Regards
SP