Skip to content

Instantly share code, notes, and snippets.

@Shpigford
Created September 8, 2024 18:06
Show Gist options
  • Save Shpigford/00345df17e0496108143fcfe99b1bd99 to your computer and use it in GitHub Desktop.
Save Shpigford/00345df17e0496108143fcfe99b1bd99 to your computer and use it in GitHub Desktop.
Digital Ocean Postgres Permissions
REVOKE ALL ON DATABASE demo_database FROM demo_user;
GRANT CONNECT ON DATABASE demo_database TO demo_user;
GRANT USAGE, CREATE ON SCHEMA public TO demo_user;
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO demo_user;
GRANT USAGE ON ALL SEQUENCES IN SCHEMA public TO demo_user;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO demo_user;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT USAGE ON SEQUENCES TO demo_user;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment