Re: GRANT CONNECT ON DATABASE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Edwin UY <edwin.uy@xxxxxxxxx>
Subject: Re: GRANT CONNECT ON DATABASE
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Sun, 9 Jun 2024 17:30:30 -0700
Cc: soroush jurat <srsh.jurat@xxxxxxxxx>, "pgsql-admin@xxxxxxxxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <CA+wokJ_go6xvLCTBNyNC_CVfYXGyZ8qkV26X5r7LhTB2+odFMw@mail.gmail.com>
References: <CA+wokJ8-z3sXJbrWHoxEVa2dV2Qsp2OyqyzdJBa3rvhWOEyXOg@mail.gmail.com> <CAFgVK8t_1cYr-hxJB4xbvYotC0GxZWWfT+CNx3dxRhqxexYVEQ@mail.gmail.com> <CA+wokJ_go6xvLCTBNyNC_CVfYXGyZ8qkV26X5r7LhTB2+odFMw@mail.gmail.com>

On Sunday, June 9, 2024, Edwin UY <edwin.uy@xxxxxxxxx> 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.

References:
- GRANT CONNECT ON DATABASE
  - From: Edwin UY
- Re: GRANT CONNECT ON DATABASE
  - From: soroush jurat
- Re: GRANT CONNECT ON DATABASE
  - From: Edwin UY

Prev by Date: Re: GRANT CONNECT ON DATABASE
Next by Date: Re: GRANT CONNECT ON DATABASE
Previous by thread: Re: GRANT CONNECT ON DATABASE
Next by thread: Re: GRANT CONNECT ON DATABASE
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]

Powered by Linux