logoalt Hacker News

direwolf20today at 2:30 AM1 replyview on HN

Isn't it something like GRANT ALL ON DATABASE foo TO USER bar


Replies

mulmentoday at 4:03 AM

Grant operates on objects that already exist. They probably want ALTER DEFAULT PRIVILEGES or maybe just a superuser. The Postgres docs are actually really really good. https://www.postgresql.org/docs/current/sql-alterdefaultpriv... https://www.postgresql.org/docs/current/role-attributes.html