does anybody know how to check user permissions for a foreign table on Postgres?
I've tried \dE
and \det
, but no luck.
I just want to know who can select, insert, update and delete from a foreign table.
\dp
is a psql meta-command which lists tables with their associated access privileges. I believe \z
is doing the same thing. It also lists privileges for accessing views and sequences.