Postgres Pro
Downloads
Home   >   mailing lists

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

From Rob Sargent
Subject Re: connect permission based on database name
Date
Msg-id 574d44d9-1900-75e3-7c01-e93c5a92ea0c@gmail.com
Whole thread Raw
In response to Re: connect permission based on database name  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
On 5/25/22 08:20, Tom Lane wrote:
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
Yes, of course.  Thanks

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: connect permission based on database name
Next
From: Carsten Klein
Date:
Subject: Connect to specific cluster on command line