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

"Please Note:
  • At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
  • This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

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

« 
Previous topic
|
Install & configuration
|
Next topic
 »
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