As far as I understand there are set of default Postgres public privileges. I have created user and granted him privilege using:
CREATE USER foo WITH PASSWORD 'foo';
\connect bar;
GRANT SELECT ON ALL TABLES IN SCHEMA public to foo;
and I can connect to DB with no issues. Then I taught I must have connection privilege in the default privilege set, since I didn't grant connect on database
explicitly.
When I do \ddp
I get 0 rows, and as far as I understood it is a way of checking default privileges per [this page](https://www.postgresql.org/docs/9.0/sql-alterdefaultprivileges.html) .
Can someone help me understand how connecting to the DB is permitted when I haven't explicitly allowed it?
Asked by Dusan Gligoric
(51 rep)
Apr 16, 2020, 01:43 PM
Last activity: May 3, 2025, 06:09 PM
Last activity: May 3, 2025, 06:09 PM