changeset 2377 | 5b148ee677de |
parent 2376 | 20b65f046002 |
child 2378 | c1a29f63c714 |
--- 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;