DMARC-Filter: OpenDMARC Filter v1.3.2 mta-p7.oit.umn.edu 4XLRVR2fWsz9vBrx
MIME-Version: 1.0
From: Matt Zagrabelny <mzagrabe@d.umn.edu>
Date: Sat, 5 Oct 2024 08:44:32 -0500
Message-ID: <CAOLfK3Vj-PFBJi28y1170ZP3dGeW2qpG_8_9CbaJWvEgXQ8-jQ@mail.gmail.com>
Subject: grant connect to all databases
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000008a81ff0623bafdf5"
Archived-At: <https://www.postgresql.org/message-id/CAOLfK3Vj-PFBJi28y1170ZP3dGeW2qpG_8_9CbaJWvEgXQ8-jQ%40mail.gmail.com>
Precedence: bulk

--0000000000008a81ff0623bafdf5
Content-Type: text/plain; charset="UTF-8"

Hello,

I'd like to have a read-only user for all databases.

I found the pg_read_all_data role predefined role, which I granted to my RO
user:

GRANT pg_read_all_data TO ro_user;

...but I cannot connect to my database(s).

I'd like to not have to iterate over all the databases and "GRANT
CONNECT...".

Is there a way to do this with just one GRANT or equivalent command?

Thanks for any help!

-m

--0000000000008a81ff0623bafdf5
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hello,</div><div><br></div><div>I&#39;d like to have =
a read-only user for all databases.</div><div><br></div><div>I found the pg=
_read_all_data role predefined role, which I granted to my RO user:</div><d=
iv><br></div><div>GRANT pg_read_all_data TO ro_user;</div><div><br></div><d=
iv>...but I cannot connect to my database(s).</div><div><br></div><div>I=
9;d like to not have to iterate over all the databases and &quot;GRANT CONN=
ECT...&quot;.</div><div><br></div><div>Is there a way to do this with just =
one GRANT or equivalent command?</div><div><br></div><div>Thanks for any he=
lp!</div><div><br></div><div>-m<br></div></div>

--0000000000008a81ff0623bafdf5--