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
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 |
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 |