PostgreSQL database privilege confusion

Question

What does it mean if \l shows no database privileges for any user whatsoever on a certain database, but, has_database_privilege() confirms ALL privileges are present for a certain role (which is validated by the fact that the role can indeed connect to the database). Is this even a possible situation? Happening on version 10.15.

Please post your shell/terminal session. Where you specifying /l? What login are you using? — Dai
– Dai, Commented Mar 13, 2021 at 1:46

jjanes · Accepted Answer · 2021-03-13 03:45:21Z

1

If \l shows absolutely no privileges information for a database, it means that the database has default privileges. The default is for PUBLIC to have CONNECT and TEMP (but not CREATE).

has_database_privilege will count privileges of PUBLIC as being possessed by any named user, so it may show 'true' even though \l doesn't explicitly list them.

answered Mar 13, 2021 at 3:45

jjanes

44.9k5 gold badges39 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL database privilege confusion

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related