Skip to content

Instantly share code, notes, and snippets.

@uurtech
Created January 23, 2024 15:48
Show Gist options
  • Save uurtech/9c6b9eefa85ac6eb0c38c105fdf99a1e to your computer and use it in GitHub Desktop.
Save uurtech/9c6b9eefa85ac6eb0c38c105fdf99a1e to your computer and use it in GitHub Desktop.
Target RDS
CREATE USER your_user WITH LOGIN PASSWORD 'your_password';
GRANT USAGE ON SCHEMA schema_name TO your_user;
GRANT CONNECT ON DATABASE db_name to your_user;
GRANT CREATE ON DATABASE db_name TO your_user;
GRANT CREATE ON SCHEMA schema_name TO your_user;
GRANT UPDATE, INSERT, SELECT, DELETE, TRUNCATE ON ALL TABLES IN SCHEMA schema_name TO your_user;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment