Essential User Permission SQL Commands for PostgreSQL

Table of Contents

  • Give SELECT permissions on all tables to a specific user
GRANT SELECT ON ALL TABLES IN SCHEMA public TO user;
  • Set SELECT permissions on all tables for all future tablesto a specific user.
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO looker;