ERROR: permission denied for relation

From wikieduonline
Revision as of 11:55, 27 September 2022 by Ant (talk | contribs) (→‎Related)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

GRANT ALL PRIVILEGES ON TABLE your-table TO your-user;

SELECT grantee, privilege_type FROM information_schema.role_table_grants WHERE table_name='mytable';

SELECT grantor, grantee, table_schema, table_name, privilege_type FROM information_schema.table_privileges WHERE grantee = 'myuser'


See also[edit]