Postgres Pro
Downloads
Home   >   mailing lists

Re: connect permission based on database name - Mailing list pgsql-general

From Tom Lane
Subject Re: connect permission based on database name
Date
Msg-id 1920549.1653488423@sss.pgh.pa.us
Whole thread Raw
In response to connect permission based on database name  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: connect permission based on database name
Re: connect permission based on database name
List pgsql-general
Tree view 
Rob Sargent <robjsargent@gmail.com> writes:
> Just wondering if I've bumped into some security issue.
> I'm somewhat surprised that "grant connect to database <dbname>  to 
> <role>" appears to be stored "by name"?

I think you are forgetting that databases have a default GRANT CONNECT
TO PUBLIC.  You need to revoke that before other grants/revokes will
have any functional effect.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PG 13.6 : Data corruption error message not being sent to syslog
Next
From: Rob Sargent
Date:
Subject: Re: connect permission based on database name