Revoke role options.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Tue, 08 Oct 2019 21:19:29 +0300
changeset 2385 0c07e8df092f
parent 2384 39bedf1e6b4e
child 2386 91e528090168
Revoke role options.
postgres.rst
--- a/postgres.rst	Sun Sep 29 14:24:58 2019 +0300
+++ b/postgres.rst	Tue Oct 08 21:19:29 2019 +0300
@@ -104,10 +104,19 @@
 
 Grant role options
 ==================
-::
+
+Show role options and group membership::
+
+  \du
+
+Grant role options::
 
-   ALTER USER me WITH SUPERUSER;
-   ALTER USER me WITH CREATEDB CREATEROLE LOGIN;
+  ALTER USER me WITH SUPERUSER;
+  ALTER USER me WITH CREATEDB CREATEROLE LOGIN;
+
+Revoke role options::
+
+  ALTER USER me WITH NOSUPERUSER;
 
 https://www.postgresql.org/docs/current/sql-createrole.html
   ``CREATE ROLE``.