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
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.

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: 945
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: 10015
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: 945
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: 10015
Joined: Wed Aug 10, 2005 12:56 pm


Return to OJS Technical Support

Who is online

Users browsing this forum: No registered users and 1 guest