I was hoping to find one or more tables in Canvas Data that contains account roles (that is, admin-like roles) and also enrollments of this type, but I'm having trouble locating this. Does it exist? (in either CD1 or CD2?). Assuming it does not, is the plan to include this in the CD2 roadmap?
Solved! Go to Solution.
I believe you'll find what you're looking for in the account_users table. Role IDs are defined in the roles table -- look for records that have a base_role_type of AccountMembership.