Tag Info

New answers tagged

2

Also addressing the question in the comments. Role public Per documentation: The key word PUBLIC indicates that the privileges are to be granted to all roles, including those that might be created later. PUBLIC can be thought of as an implicitly defined group that always includes all roles. Bold emphasis mine. Membership in public cannot be ...


1

To address the question of why test can SELECT from tables without a GRANT, it is because you have not explicitly run REVOKE for the ability to connect to your database(s) from PUBLIC, and then explicitly run GRANT for your test user: REVOKE connect ON DATABASE testdb FROM PUBLIC; GRANT connect ON DATABASE testdb TO test; Once that is done, you would ...



Top 50 recent answers are included