Hello,
I want to programmatically read all the references in a database. Ideally,
I want to do it with read-only permissions to the table. Is it possible?
I know the information is in `information_schema.referential_constraints`,
but apparently reading that information requires having write permissions
to the tables that have references. I don't know why it's designed like
that. I think knowing the relationships between tables is in the same class
of privileges as knowing the columns in the tables. (which you can do by
reading the `columns` view with just SELECT permissions)
Anyway, is there a workaround for this? If not, what is the least
destructive write permission I can give a user who wants this access?
Cheers,
Avin.