author | Oleksandr Gavenko <gavenkoa@gmail.com> |
Sun, 15 Sep 2019 23:39:13 +0300 (2019-09-15) | |
changeset 2374 | e050994e0810 |
parent 2373 | 07d81edeaba6 |
child 2375 | c2bfaae890f8 |
postgres.rst | file | annotate | diff | comparison | revisions |
--- a/postgres.rst Sun Sep 15 00:06:40 2019 +0300 +++ b/postgres.rst Sun Sep 15 23:39:13 2019 +0300 @@ -88,6 +88,12 @@ GRANT SELECT ON ALL TABLES IN SCHEMA public TO user2; +Making read-only role:: + + GRANT CONNECT ON DATABASE mydb TO ro; + GRANT USAGE ON SCHEMA myschema TO ro; + GRANT SELECT ON TABLE myschema.myt1, myschema.myt2 TO ro; + Change password =============== ::