Difference between revisions of "Information schema"
Jump to navigation
Jump to search
| (4 intermediate revisions by 2 users not shown) | |||
| Line 2: | Line 2: | ||
| − | select * from information_schema.[[role_table_grants]] where grantee='YOUR_USER'; | + | [[select]] * from information_schema.[[role_table_grants]] where grantee='YOUR_USER'; |
grantor grantee .../... | grantor grantee .../... | ||
| − | == | + | == Related == |
* <code>[[psql -l]]</code> | * <code>[[psql -l]]</code> | ||
| + | * <code>[[ERROR: permission denied for your-table]]</code> | ||
| + | == See also == | ||
| + | * {{SELECT}} | ||
| − | [[PostgreSQL | + | [[Category:PostgreSQL]] |
Latest revision as of 15:26, 15 December 2022
select * from information_schema.role_table_grants where grantee='YOUR_USER';
grantor grantee .../...
Related[edit]
See also[edit]
Advertising:
