SyntaxFix

[postgresql] Check Postgres access for a user

You could query the table_privileges table in the information schema:

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

Examples related to postgresql

• Subtracting 1 day from a timestamp date • pgadmin4 : postgresql application server could not be contacted. • Psql could not connect to server: No such file or directory, 5432 error? • How to persist data in a dockerized postgres database using volumes • input file appears to be a text format dump. Please use psql • Postgres: check if array field contains value? • Add timestamp column with default NOW() for new rows only • Can't connect to Postgresql on port 5432 • How to insert current datetime in postgresql insert query • Connecting to Postgresql in a docker container from outside

Examples related to privileges

• Check Postgres access for a user • Give all permissions to a user on a PostgreSQL database • ORA-01950: no privileges on tablespace 'USERS' • Getting ORA-01031: insufficient privileges while querying a table instead of ORA-00942: table or view does not exist • Remove privileges from MySQL database • Permission denied for relation • How to view user privileges using windows cmd? • Grant all on a specific schema in the db to a group role in PostgreSQL • How to show all privileges from a user in oracle? • What precisely does 'Run as administrator' do?

Examples related to data-dictionary

• Check Postgres access for a user