# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1568579953 -10800
# Node ID e050994e0810a9389628d5671edcc0f6d0e682f9
# Parent  07d81edeaba6f1ea314aa750175594cebbcbc107
Making read-only role.

diff -r 07d81edeaba6 -r e050994e0810 postgres.rst
--- 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
 ===============
 ::