Hi David,
David G. Johnston schreef op 2023-08-01 19:35:
On Tue, Aug 1, 2023 at 10:13 AM William Edwards
wrote:
This allows all local users connecting over TCP to access all
databases,
not only the databases that the user is a member of as one might
expect.
Proof that user is able to access
On Tue, Aug 1, 2023 at 10:13 AM William Edwards
wrote:
> This allows all local users connecting over TCP to access all databases,
> not only the databases that the user is a member of as one might expect.
>
> Proof that user is able to access database that it is not a member of is
> below.
Role
> On Aug 1, 2023, at 10:13, William Edwards wrote:
> This allows all local users connecting over TCP to access all databases, not
> only the databases that the user is a member of as one might expect.
There's really no notion of a user being "a member of" a database in
PostgreSQL. Users are