# HG changeset patch # User Oleksandr Gavenko # Date 1568580051 -10800 # Node ID c2bfaae890f836663bb912a687637a553269fc3e # Parent e050994e0810a9389628d5671edcc0f6d0e682f9 Granting selects. diff -r e050994e0810 -r c2bfaae890f8 postgres.rst --- a/postgres.rst Sun Sep 15 23:39:13 2019 +0300 +++ b/postgres.rst Sun Sep 15 23:40:51 2019 +0300 @@ -86,7 +86,8 @@ Granting selects:: - GRANT SELECT ON ALL TABLES IN SCHEMA public TO user2; + GRANT SELECT ON ALL TABLES IN SCHEMA public TO ro_user; + GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO rw_user; Making read-only role::