On 10/5/24 11:24, Matt Zagrabelny wrote:
Nope. I create the role (via puppet) and then add the GRANT
pg_read_all_data TO (via puppet).
What is \drgS? I don't believe I have that.
That is available in Postgres 16+, you must running be in an instance of
Postgres before that.
'CREATE ROLE "alice" ENCRYPTED PASSWORD \'$NEWPGPASSWD\' LOGIN
NOCREATEROLE NOCREATEDB NOSUPERUSER CONNECTION LIMIT -1'
GRANT pg_read_all_data TO alice;
...but I still cannot connect:
$ psql -d test -U alice
psql: error: connection to server on socket
"/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: permission denied
for database "test"
DETAIL: User does not have CONNECT privilege.
Something is going on in the background.
What version of Postgres?
Where did you install it from or where are you running it?
Thanks for the help!
-m
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
