author | Oleksandr Gavenko <gavenkoa@gmail.com> |
Mon, 16 Sep 2019 22:40:00 +0300 (2019-09-16) | |
changeset 2378 | c1a29f63c714 |
parent 2377 | 5b148ee677de |
child 2379 | a38f029fcf84 |
postgres.rst | file | annotate | diff | comparison | revisions |
--- a/postgres.rst Mon Sep 16 22:33:19 2019 +0300 +++ b/postgres.rst Mon Sep 16 22:40:00 2019 +0300 @@ -130,6 +130,9 @@ SELECT * FROM pg_roles; + SELECT oid, rolname FROM pg_roles + WHERE pg_has_role('xuser', oid, 'member'); + Revoke privileges:: REVOKE ALL PRIVILEGES ON DATABASE mydb FROM xuser; @@ -176,6 +179,12 @@ Monitor connections =================== + +Current user:: + + SELECT current_user; + SELECT session_user; + :: select * from pg_stat_activity;