Mass convert users to admin

Questions about the backend functionalities: configuration, user management, course management, ...
Post Reply
Posts: 12
Joined: Tue Aug 27, 2013 1:00 am

Mass convert users to admin

Post by jeffgtr » Mon Jul 30, 2018 7:38 pm

I am upgrading to Froma 2.0 which moves public admins to users.

I am hoping to run a query that will update users that were formerly public admins to admins with an admin profile.

Looking through the database it appears that in the users table "core_users" field "level" should specify that they are a user or administrator.
Within User management I have set a user to Admin however when I look them up in the database the level is still "0"

Is there another table that links user ID's to roles (such as Administrator) additionally is there a table that assigns an user an Admin Profile?

User avatar
FormaLms Guru
Posts: 911
Joined: Fri Mar 02, 2012 9:18 am

Re: Mass convert users to admin

Post by alberto » Tue Jul 31, 2018 7:40 am

No need for any db query, you can easily mass edit user level from user management:

1. Select the users you need to edit
2. Click on the "More Actions" link at the top or the bottom of the user list
3. Click edit
4. Set the desired level and save

Support the project for FREE!

Post Reply