problem with read-only user

From: ROS Didier <didier(dot)ros(at)edf(dot)fr>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>, "pgsql-sql-owner(at)postgresql(dot)org" <pgsql-sql-owner(at)postgresql(dot)org>
Subject: problem with read-only user
Date: 2019-12-20 13:01:50
Message-ID: 0d4a7143cb7b4a749ca7e4603e6a795e@PCYINTPEXMU001.NEOPROD.EDF.FR
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

Hi
I created a read-only role as follows:
psql -p 5434 kidsdpn03
CREATE ROLE kidsdpn03_ro PASSWORD 'xxx';
ALTER ROLE kidsdpn03_ro WITH LOGIN;
GRANT CONNECT ON DATABASE kidsdpn03 TO kidsdpn03_ro;
GRANT USAGE ON SCHEMA kidsdpn03 TO kidsdpn03_ro;
GRANT SELECT ON ALL TABLES IN SCHEMA kidsdpn03 TO kidsdpn03_ro;
GRANT SELECT ON ALL SEQUENCES IN SCHEMA kidsdpn03 TO kidsdpn03_ro;
ALTER DEFAULT PRIVILEGES IN SCHEMA kidsdpn03 GRANT SELECT ON TABLES TO kidsdpn03_ro;
ALTER ROLE kidsdpn03_ro SET search_path TO kidsdpn03;

but when i create new tables, i don't have read access to those new tables.
Anybody can help to solve this problem ?
Thank you in advance

Didier ROS
didier(dot)ros(at)edf(dot)fr

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2019-12-20 13:07:00 Re: Optimizing TransactionIdIsCurrentTransactionId()
Previous Message Michael Paquier 2019-12-20 12:02:08 Re: pgsql: Superuser can permit passwordless connections on postgres_fdw

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2019-12-20 14:04:57 Re: problem with read-only user
Previous Message Rob Sargent 2019-12-02 21:14:26 Re: Solving my query needs with Rank and may be CrossTab