Skip to content

Instantly share code, notes, and snippets.

@whyvez

whyvez/grant.sql

Created January 7, 2016 18:13
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save whyvez/b09ea9a52160c469523a to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save whyvez/b09ea9a52160c469523a to your computer and use it in GitHub Desktop.
Download ZIP
grant a role read privilege on tables in specific schemas
Raw
grant.sql
CREATE ROLE pgyiadmin WITH LOGIN;
GRANT SELECT ON ALL TABLES IN SCHEMA psp, staging TO pgyiadmin;
GRANT USAGE ON SCHEMA psp, staging TO pgyiadmin;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment