equal
deleted
inserted
replaced
84 https://www.postgresql.org/docs/current/sql-createrole.html |
84 https://www.postgresql.org/docs/current/sql-createrole.html |
85 ``CREATE ROLE``. |
85 ``CREATE ROLE``. |
86 |
86 |
87 Granting selects:: |
87 Granting selects:: |
88 |
88 |
89 GRANT SELECT ON ALL TABLES IN SCHEMA public TO user2; |
89 GRANT SELECT ON ALL TABLES IN SCHEMA public TO ro_user; |
|
90 GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO rw_user; |
90 |
91 |
91 Making read-only role:: |
92 Making read-only role:: |
92 |
93 |
93 GRANT CONNECT ON DATABASE mydb TO ro; |
94 GRANT CONNECT ON DATABASE mydb TO ro; |
94 GRANT USAGE ON SCHEMA myschema TO ro; |
95 GRANT USAGE ON SCHEMA myschema TO ro; |