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@example.com | 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
      );