Change current users to site admins [RESOLVED]

[Gizzard]

Hi

I have a request from a user who is taking over the OJS site admin's position - she needs to be setup as the "God(ess)" of OJS on our system. I could just change the credentials of the admin user, but her email address is used as a regular user. Also, I can't see what database flags indicate that a user is the overall OJS administrator and has rights to everything. If I know that, then I can issue a SQL statement to change the authorisation on her existing account.

Any help would be most appreciated.

Thanks
Gizzard.

[smiri]

Hi There,

I believe you can do what you want by just modifying the roles table. Have a look at the row of your roles table where "conference_id" and "sched_conf_id" are both 0. That's the site admin user.

Something like this SQL command could accomplish what you want. (Please note that this will add a second site admin. If you'd like to replace the existing site admin, then you should change the value of the already existing row):

Code: Select all

insert into roles (conference_id, sched_conf_id, user_id, role_id) values (0,0,[user_id],1);

Regards,

[Gizzard]

Hi Siavash

That's exactly what I needed to know. Thanks for your help.

Kind regards
Gary

[ramon]

Hello all,

This is not working for OCS 2.3.3.2...
Any ideas on how to add another Admin?

[asmecher]

Hi Ramón,

Could you post this in the OCS forum?

Thanks,
Alec Smecher
Public Knowledge Project Team

[ramon]

Hi Alec,

Sorry for cross posting.
Please remove this post.
I've posted on the appropriate forum, with a reference to this post.

[asmecher]

Hi Ramón,

No need to apologize, or remove any postings -- links between the threads will probably come in handy.

(Note that the SQL statement above is for OCS; for OJS, use the following:)

Code: Select all

insert into roles (journal_id, user_id, role_id) values (0,[user_id],1);

Regards,
Alec Smecher
Public Knowledge Project Team