Skip to content

Instantly share code, notes, and snippets.

@martjanz

martjanz/snippet.sql

Last active June 8, 2020 22:43
Show Gist options
  • Save martjanz/4392fb5be843d99a11cc8a2c52dcd2cd to your computer and use it in GitHub Desktop.
Save martjanz/4392fb5be843d99a11cc8a2c52dcd2cd to your computer and use it in GitHub Desktop.
Download ZIP
[Create database user to view/copy only] #postgresql
Raw
snippet.sql
CREATE ROLE downloader NOSUPERUSER NOCREATEDB NOCREATEROLE NOINHERIT LOGIN PASSWORD 'the-password';
GRANT CONNECT ON DATABASE db_name TO downloader;
GRANT ALL ON SCHEMA public TO downloader;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO downloader;
GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO downloader;
ALTER DEFAULT PRIVILEGES IN SCHEMA public
GRANT SELECT ON TABLES TO downloader;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment