Skip to content

Instantly share code, notes, and snippets.

@0xKD

0xKD/readonly.sql

Created June 10, 2021 13:08
Show Gist options
  • Save 0xKD/19b05962bb792466a7f51c7027a17c49 to your computer and use it in GitHub Desktop.
Save 0xKD/19b05962bb792466a7f51c7027a17c49 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
readonly.sql
CREATE USER readonly WITH PASSWORD 'supersecret';
GRANT SELECT ON ALL TABLES IN SCHEMA public TO readonly;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readonly;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment