Home > mailing lists

Re: GRANT CONNECT ON DATABASE - Mailing list pgsql-admin

From	David G. Johnston
Subject	Re: GRANT CONNECT ON DATABASE
Date	June 10 03:30:30
Msg-id	CAKFQuwbSGBY6LMe_e-MS92aK2B9r2KAO=Xd01Yad+KzK=Q-pew@mail.gmail.com Whole thread Raw
In response to	Re: GRANT CONNECT ON DATABASE (Edwin UY <edwin.uy@gmail.com>)
List	pgsql-admin

On Sunday, June 9, 2024, Edwin UY <edwin.uy@gmail.com> wrote:

Thanks. Yeah, the ALTER fixed it.
I thought the CONNECT should have done the same thing.
Is the GRANT CONNECT not necessary then?

The grant is database scoped. Login is cluster-scoped.

To log into a database requires both levels of permission.

David J.

From: Edwin UY
Date: 10 June, 03:27:29
Subject: Re: GRANT CONNECT ON DATABASE

From: soroush jurat
Date: 10 June, 03:34:49
Subject: Re: GRANT CONNECT ON DATABASE