Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I want to create a role which by default isn't allowed to do anything. It has basically zero permissions. Starting from such role, I want to grant the minimal set of permissions.
How can you make a role without any kind of permissions?
create role no_privs;
CREATE ROLE foo;
Be aware of default privileges (https://www.postgresql.org/docs/current/static/sql-alterdefaultprivileges.html).
Required, but never shown