Sample Header Ad - 728x90

Default Postgres privileges not showing on \ddp

0 votes
1 answer
1256 views
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