Skip to content

Instantly share code, notes, and snippets.

@oinopion

oinopion/read-access.sql

Created October 5, 2016 13:00
Show Gist options
  • Save oinopion/4a207726edba8b99fd0be31cb28124d0 to your computer and use it in GitHub Desktop.
Save oinopion/4a207726edba8b99fd0be31cb28124d0 to your computer and use it in GitHub Desktop.
Download ZIP
How to create read only user in PostgreSQL
Raw
read-access.sql
-- Create a group
CREATE ROLE readaccess;
-- Grant access to existing tables
GRANT USAGE ON SCHEMA public TO readaccess;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO readaccess;
-- Grant access to future tables
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readaccess;
-- Create a final user with password
CREATE USER tomek WITH PASSWORD 'secret';
GRANT readaccess TO tomek;
@bl4ck5un
Copy link

This is golden

@prosenjit-manna
Copy link

Getting permission denied error on viewing list of data from any tables

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment