Skip to content

Instantly share code, notes, and snippets.

@flaviut

flaviut/setup postgres.sql

Created August 18, 2022 03:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save flaviut/51e5f9e88603aa78efd3048a719715fd to your computer and use it in GitHub Desktop.
Save flaviut/51e5f9e88603aa78efd3048a719715fd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
setup postgres.sql
CREATE USER iam_admin;
GRANT rds_iam TO iam_admin;
grant rds_superuser to iam_admin;
CREATE USER iam_readonly;
GRANT rds_iam TO iam_readonly;
GRANT pg_read_all_data to iam_readonly;
REVOKE CREATE ON SCHEMA public FROM iam_readonly;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment