How to check list of privileges on a table in PostgreSQL

In this tutorials, we have explained how to check list of privileges on a table in PostgreSQL. We can get the privileges by using SQL statement and meta-command.

1 . SQL Statement to get list of permissions on a table.

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

2. meta-command to get list of permissions a table.

\z customer

How to check list of privileges on a table in PostgreSQL

Related Posts:

  1. Change table owner in PostgreSQL
  2. Grant and Revoke Privileges in PostgreSQL
  3. How to grant permissions on all tables to a user in PostgreSQL
  4. How to take backup and restore a PostgreSQL table