Querying Group and People tables in question

We’re sharing a bunch of questions with people from external organizations (groups) and it would be useful for them to have a list of their colleagues who have access to those questions. Is it possible to make a question that queries the internal permission tables (group, people)?

Hi @naokoon
Yes, you can add the internal metadata to Admin > Databases and then make queries to it.
I would recommend that you create a user in your database that only has access to the specific tables needed, since the metadata contains sensitive information.
If you don’t know where your metadata is, then you’re most likely using the default H2 database, which is not recommended in production:

1 Like