127 ===============================

   127 ===============================

   128 

   128 

   129 List roles::

   129 List roles::

   130 

   130 

   131   SELECT * FROM pg_roles;

   131   SELECT * FROM pg_roles;

   132 

   135 

   133 Revoke privileges::

   136 Revoke privileges::

   134 

   137 

   135   REVOKE ALL PRIVILEGES ON DATABASE mydb FROM xuser;

   138   REVOKE ALL PRIVILEGES ON DATABASE mydb FROM xuser;

   136   REVOKE ALL PRIVILEGES ON SCHEMA myschem FROM xuser;

   139   REVOKE ALL PRIVILEGES ON SCHEMA myschem FROM xuser;

   174 

   177 

   175    ALTER USER me WITH PASSWORD 'PassWord';

   178    ALTER USER me WITH PASSWORD 'PassWord';

   176 

   179 

   177 Monitor connections

   180 Monitor connections

   178 ===================

   181 ===================

   179 ::

   188 ::

   180 

   189 

   181    select * from pg_stat_activity;

   190    select * from pg_stat_activity;

   182 

   191 

   183 https://www.postgresql.org/docs/current/monitoring-stats.html

   192 https://www.postgresql.org/docs/current/monitoring-stats.html