# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1570558769 -10800
# Node ID 0c07e8df092f254558274255dd02e0e3858ce435
# Parent  39bedf1e6b4e5eab285f5959303b4c43b6e88af8
Revoke role options.

diff -r 39bedf1e6b4e -r 0c07e8df092f 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``.