df.fr
Tél. : +33 6 49 51 11 88
-Message d'origine-
De : t...@sss.pgh.pa.us [mailto:t...@sss.pgh.pa.us]
Envoyé : vendredi 20 décembre 2019 15:05
À : ROS Didier
Cc : pgsql-hack...@postgresql.org; pgsql-...@postgresql.org
Objet : Re: problem with read-only user
ROS Didier writes:
>
ROS Didier writes:
> 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 TABL
