Re: Accessing referential constraint information with minimal permissions

2023-06-24 Thread Christoph Moench-Tegeder
## Avin Kavish (a...@baseboard.ai): > 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 guess because "the stand

Accessing referential constraint information with minimal permissions

2023-06-24 Thread Avin Kavish
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 permi