Granting selects.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Sun, 15 Sep 2019 23:40:51 +0300
changeset 2375 c2bfaae890f8
parent 2374 e050994e0810
child 2376 20b65f046002
Granting selects.
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::