OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Change current users to site admins [RESOLVED]

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
What to do if you have a technical problem with OJS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a development question, try the OJS Development subforum.

Change current users to site admins [RESOLVED]

Postby Gizzard » Sun Mar 09, 2008 10:48 pm

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.
Gizzard
 
Posts: 44
Joined: Sun Jun 17, 2007 8:40 pm

Re: Change current users to site admins

Postby smiri » Mon Mar 10, 2008 6:20 pm

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,
smiri
 
Posts: 183
Joined: Thu Sep 06, 2007 7:01 pm

Re: Change current users to site admins

Postby Gizzard » Mon Mar 10, 2008 6:58 pm

Hi Siavash

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

Kind regards
Gary
Gizzard
 
Posts: 44
Joined: Sun Jun 17, 2007 8:40 pm

Re: Change current users to site admins [RESOLVED]

Postby ramon » Wed Jun 01, 2011 7:34 am

Hello all,

This is not working for OCS 2.3.3.2...
Any ideas on how to add another Admin?
ramon
 
Posts: 931
Joined: Wed Oct 15, 2003 6:15 am
Location: Brasí­lia/DF - Brasil

Re: Change current users to site admins [RESOLVED]

Postby asmecher » Wed Jun 01, 2011 9:26 am

Hi Ramón,

Could you post this in the OCS forum?

Thanks,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8905
Joined: Wed Aug 10, 2005 12:56 pm

Re: Change current users to site admins [RESOLVED]

Postby ramon » Wed Jun 01, 2011 11:25 am

Hi Alec,

Sorry for cross posting.
Please remove this post.
I've posted on the appropriate forum, with a reference to this post.
ramon
 
Posts: 931
Joined: Wed Oct 15, 2003 6:15 am
Location: Brasí­lia/DF - Brasil

Re: Change current users to site admins [RESOLVED]

Postby asmecher » Wed Jun 01, 2011 11:30 am

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
asmecher
 
Posts: 8905
Joined: Wed Aug 10, 2005 12:56 pm


Return to OJS Technical Support

Who is online

Users browsing this forum: Google [Bot], Yahoo [Bot] and 3 guests