changeset 2385:0c07e8df092f

Revoke role options.
author Oleksandr Gavenko <gavenkoa@gmail.com>
date Tue, 08 Oct 2019 21:19:29 +0300
parents 39bedf1e6b4e
children 91e528090168
files postgres.rst
diffstat 1 files changed, 12 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- 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``.