Tag: permissions

How to grant permissions on all tables to a user in PostgreSQL

In this article, we will see how to grant permissions on all tables to a user in PostgreSQL.

Syntax:

GRANT SELECT, INSERT, UPDATE, DELETE
ON ALL TABLES IN SCHEMA public 
TO user_name;

Examples:

1. First grant CONNECT to database using below syntax.
Continue reading How to grant permissions on all tables to a user in PostgreSQL

Related Posts:

  1. Change table owner in PostgreSQL
  2. Grant and Revoke Privileges in PostgreSQL
  3. How to check list of privileges on a table in PostgreSQL
  4. How to get the PostgreSQL table structure