I am interested in delegating access to Canvas hosted data via subaccounts. E.g. giving the English department access to all data for English courses. From what I've seen of the tables so far, I should be able to create views that derive subtables based on linking back through the course_dim and account_dim tables.
The one piece that's missing is the ability to create psql accounts for users. Is it possible to add an account that rights to create accounts and grant read access on views?
As a bigger question - is this a bad idea, and are there any plans to support something like this in a central way?