equal
deleted
inserted
replaced
102 |
102 |
103 SELECT * FROM pg_default_acl; |
103 SELECT * FROM pg_default_acl; |
104 |
104 |
105 Grant role options |
105 Grant role options |
106 ================== |
106 ================== |
107 :: |
107 |
108 |
108 Show role options and group membership:: |
109 ALTER USER me WITH SUPERUSER; |
109 |
110 ALTER USER me WITH CREATEDB CREATEROLE LOGIN; |
110 \du |
|
111 |
|
112 Grant role options:: |
|
113 |
|
114 ALTER USER me WITH SUPERUSER; |
|
115 ALTER USER me WITH CREATEDB CREATEROLE LOGIN; |
|
116 |
|
117 Revoke role options:: |
|
118 |
|
119 ALTER USER me WITH NOSUPERUSER; |
111 |
120 |
112 https://www.postgresql.org/docs/current/sql-createrole.html |
121 https://www.postgresql.org/docs/current/sql-createrole.html |
113 ``CREATE ROLE``. |
122 ``CREATE ROLE``. |
114 |
123 |
115 Granting selects:: |
124 Granting selects:: |