undefined | Better HN

0 pointsdirewolf201mo ago0 comments

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

0 comments

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

j / k navigate · click thread line to collapse

0 pointsdirewolf201mo ago0 comments

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

mulmen1mo ago

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

j / k navigate · click thread line to collapse