DROP OWNED BY.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Mon, 16 Sep 2019 22:33:19 +0300
changeset 2377 5b148ee677de
parent 2376 20b65f046002
child 2378 c1a29f63c714
DROP OWNED BY.
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;