# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1568662399 -10800
# Node ID 5b148ee677de15998d22b4f6b5e67950d3f9558c
# Parent  20b65f046002472139cd14cd4198124e45cfcda7
DROP OWNED BY.

diff -r 20b65f046002 -r 5b148ee677de postgres.rst
--- a/postgres.rst	Mon Sep 16 22:13:19 2019 +0300
+++ b/postgres.rst	Mon Sep 16 22:33:19 2019 +0300
@@ -81,6 +81,10 @@
 
   \l
 
+List schemas with privileges::
+
+  \dn+
+
 List users with privileges::
 
   \du
@@ -156,6 +160,10 @@
 
   REASSIGN OWNED BY xuser TO myuser;
 
+Some objects may left behind role (like default privileges), they can be dropped via::
+
+  DROP OWNED BY xuser;
+
 Remove role::
 
   DROP ROLE xuser;