PG information_schema

Creator

Creator

Seonglae Cho

Created

Created

2021 Jan 5 8:16

Editor

Editor

Seonglae Cho

Edited

Edited

2021 Apr 7 1:35

Refs

Refs

check table authority


SELECT table_catalog, table_schema, table_name, privilege_type
FROM   information_schema.table_privileges 
WHERE  grantee = 'MY_USER'

Check Postgres access for a user

Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. Provide details and share your research! Asking for help, clarification, or responding to other answers. Making statements based on opinion; back them up with references or personal experience. To learn more, see our tips on writing great answers.

https://stackoverflow.com/questions/26917508/check-postgres-access-for-a-user/26917620

Recommendations

/////////