Re: GRANT CONNECT ON DATABASE

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Edwin UY <edwin(dot)uy(at)gmail(dot)com>
Cc: soroush jurat <srsh(dot)jurat(at)gmail(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: GRANT CONNECT ON DATABASE
Date: 2024-06-10 00:30:30
Message-ID: CAKFQuwbSGBY6LMe_e-MS92aK2B9r2KAO=Xd01Yad+KzK=Q-pew@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sunday, June 9, 2024, Edwin UY <edwin(dot)uy(at)gmail(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message soroush jurat 2024-06-10 00:34:49 Re: GRANT CONNECT ON DATABASE
Previous Message Edwin UY 2024-06-10 00:27:29 Re: GRANT CONNECT ON DATABASE