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

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

eZ debug

Timing:	Jan 30 2025 22:26:52
Script start
Timing:	Jan 30 2025 22:26:52
Module start 'layout'
Timing:	Jan 30 2025 22:26:52
Module start 'content'
Timing:	Jan 30 2025 22:26:52
Module end 'content'
Timing:	Jan 30 2025 22:26:52
Script end

Main resources:

Total runtime	0.0315 sec
Peak memory usage	4,096.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0085	588.6172	151.2734
Module start 'layout'	0.0085	0.0042	739.8906	220.7656
Module start 'content'	0.0127	0.0168	960.6563	997.8984
Module end 'content'	0.0295	0.0020	1,958.5547	29.9922
Script end	0.0315		1,988.5469

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0027	8.6846	14	0.0002
Check MTime	0.0011	3.5428	14	0.0001
Mysql Total
Database connection	0.0010	3.1963	1	0.0010
Mysqli_queries	0.0051	16.0850	3	0.0017
Looping result	0.0000	0.0310	1	0.0000
Template Total	0.0015	4.6	1	0.0015
Template load	0.0012	3.7797	1	0.0012
Template processing	0.0003	0.8187	1	0.0003
Override
Cache load	0.0008	2.5327	1	0.0008
General
dbfile	0.0003	0.8081	8	0.0000
String conversion	0.0000	0.0219	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs