Locking Down Permissions in PostgreSQL and Redshift

Posted on Mon 02 October 2017 in Database Grants • Tagged with database, grants, postgresql, redshift, security • 5 min read

Creating users in PostgreSQL (and by extension Redshift) that have exactly the permissions you want is, surprisingly, a difficult task. Unbeknownst to many, PostgreSQL users are automatically granted permissions due to their membership in a built-in role called PUBLIC (where a role can, in this context, be thought of as …

Continue reading