Making read-only role.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Sun, 15 Sep 2019 23:39:13 +0300
changeset 2374 e050994e0810
parent 2373 07d81edeaba6
child 2375 c2bfaae890f8
Making read-only role.
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
 ===============
 ::