Steve Heslouin steve-heslouin

steve-heslouin / rw_ro_access.sql

Created May 15, 2023 21:01 — forked from checco/rw_ro_access.sql

How to create a read only user in AWS RDS PostgreSQL and a user with superuser privileges on AWS RDS PostgreSQL

	--
	-- Read only
	--

	-- Create a group
	CREATE ROLE postgres_ro_group;

	-- Grant access to existing tables
	GRANT USAGE ON SCHEMA public TO postgres_ro_group;
	GRANT SELECT ON ALL TABLES IN SCHEMA public TO postgres_ro_group;