author | Oleksandr Gavenko <gavenkoa@gmail.com> |
Mon, 16 Sep 2019 22:33:19 +0300 | |
changeset 2377 | 5b148ee677de |
parent 2376 | 20b65f046002 |
child 2378 | c1a29f63c714 |
postgres.rst | file | annotate | diff | comparison | revisions |
--- 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;