Admin User Setup
After setting up authentication we can elevate a user that's logged into the system to administrator status:
- Connect to the postgres database by running
psql postgres
- Check the users table by running
SELECT
*
FROM
users;
Which will display a table of users in the database:
user_id | uid | uin | name | lti_course_instance_id | lti_user_id | lti_context_id | institution_id | deleted_at
---------+------------------+-----------+----------+------------------------+-------------+----------------+----------------+------------
1 | dev@illinois.edu | 000000000 | Dev User | | | | 1 |
Add the desired user to the administrators table by running
INSERT INTO
administrators (user_id)
VALUES
(
user_id
from
users table
);