Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iiHuv-0006va-S5 for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Dec 2019 13:02:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iiHuu-0004Nf-LK for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Dec 2019 13:02:04 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iiHuu-0004Hk-4T; Fri, 20 Dec 2019 13:02:04 +0000 Received: from mtagatea.edf.fr ([163.114.23.130]) by makus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1iiHum-0005ni-Ez; Fri, 20 Dec 2019 13:02:02 +0000 Content-Type: multipart/mixed; boundary="===============8859282905288052024==" MIME-Version: 1.0 From: ROS Didier To: "pgsql-hackers@postgresql.org" , "pgsql-sql@postgresql.org" , "pgsql-sql-owner@postgresql.org" Subject: problem with read-only user Thread-Topic: problem with read-only user Thread-Index: AdW3NS/eDLC6RUr/T3i9SHHRCOE3bw== Date: Fri, 20 Dec 2019 13:01:50 +0000 Message-ID: <0d4a7143cb7b4a749ca7e4603e6a795e@PCYINTPEXMU001.NEOPROD.EDF.FR> Accept-Language: fr-FR, en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.22.153.68] x_exchange_neo: 1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============8859282905288052024== Content-Language: fr-FR Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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 kids= dpn03_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= .=20 Anybody can help to solve this problem ? Thank you in advance Didier ROS didier.ros@edf.fr --===============8859282905288052024== Content-Type: multipart/alternative; boundary="===============7837865774713459669==" MIME-Version: 1.0 Content-Disposition: inline --===============7837865774713459669== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Ce message et toutes les pi=C3=A8ces jointes (ci-apr=C3=A8s le 'Message') s= ont =C3=A9tablis =C3=A0 l'intention exclusive des destinataires et les info= rmations qui y figurent sont strictement confidentielles. Toute utilisation= de ce Message non conforme =C3=A0 sa destination, toute diffusion ou toute= publication totale ou partielle, est interdite sauf autorisation expresse. Si vous n'=C3=AAtes pas le destinataire de ce Message, il vous est interdit= de le copier, de le faire suivre, de le divulguer ou d'en utiliser tout ou= partie. Si vous avez re=C3=A7u ce Message par erreur, merci de le supprime= r de votre syst=C3=A8me, ainsi que toutes ses copies, et de n'en garder auc= une trace sur quelque support que ce soit. Nous vous remercions =C3=A9galem= ent d'en avertir imm=C3=A9diatement l'exp=C3=A9diteur par retour du message. Il est impossible de garantir que les communications par messagerie =C3=A9l= ectronique arrivent en temps utile, sont s=C3=A9curis=C3=A9es ou d=C3=A9nu= =C3=A9es de toute erreur ou virus. ____________________________________________________ This message and any attachments (the 'Message') are intended solely for th= e addressees. The information contained in this Message is confidential. An= y use of information contained in this Message not in accord with its purpo= se, any dissemination or disclosure, either whole or partial, is prohibited= except formal approval. If you are not the addressee, you may not copy, forward, disclose or use an= y part of it. If you have received this message in error, please delete it = and all copies from your system and notify the sender immediately by return= message. E-mail communication cannot be guaranteed to be timely secure, error or vir= us-free. --===============7837865774713459669== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable


Ce message et toutes les pi=C3=A8ces jointes (ci-apr=C3=A8s le 'Message') s= ont =C3=A9tablis =C3=A0 l'intention exclusive des destinataires et les info= rmations qui y figurent sont strictement confidentielles. Toute utilisation= de ce Message non conforme =C3=A0 sa destination, toute diffusion ou toute= publication totale ou partielle, est interdite sauf autorisation expresse.=

Si vous n'=C3=AAtes pas le destinataire de ce Message, il vous est inter= dit de le copier, de le faire suivre, de le divulguer ou d'en utiliser tout= ou partie. Si vous avez re=C3=A7u ce Message par erreur, merci de le suppr= imer de votre syst=C3=A8me, ainsi que toutes ses copies, et de n'en garder = aucune trace sur quelque support que ce soit. Nous vous remercions =C3=A9ga= lement d'en avertir imm=C3=A9diatement l'exp=C3=A9diteur par retour du mess= age.

Il est impossible de garantir que les communications par messagerie =C3= =A9lectronique arrivent en temps utile, sont s=C3=A9curis=C3=A9es ou d=C3= =A9nu=C3=A9es de toute erreur ou virus.
____________________________________________________

This message and any attachments (the 'Message') are intended solely for= the addressees. The information contained in this Message is confidential.= Any use of information contained in this Message not in accord with its pu= rpose, any dissemination or disclosure, either whole or partial, is prohibi= ted except formal approval.

If you are not the addressee, you may not copy, forward, disclose or use= any part of it. If you have received this message in error, please delete = it and all copies from your system and notify the sender immediately by ret= urn message.

E-mail communication cannot be guaranteed to be timely secure, error or = virus-free.

--===============7837865774713459669==-- --===============8859282905288052024==--