Revoke a user on PostgreSQL

revoke_pgsql_user.md

DBNAME=# \du
                                    List of roles
  Role name  |                         Attributes                         | Member of
-------------+------------------------------------------------------------+-----------
 user        |                                                            | {}
 postgres    | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
 dbuser      |                                                            | {}

DBNAME=# REASSIGN OWNED BY dbuser TO postgres;
REASSIGN OWNED
DBNAME=# REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA public FROM dbuser;
REVOKE
DBNAME=# REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA public FROM dbuser;
REVOKE
DBNAME=# REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public FROM dbuser;
REVOKE
DBNAME=# REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA public FROM dbuser;
REVOKE
DBNAME=# DROP USER dbuser;
ERROR:  role "dbuser" cannot be dropped because some objects depend on it
DETAIL:  privileges for database DBNAME
DBNAME=# REVOKE ALL PRIVILEGES ON DATABASE DBNAME FROM dbuser;
ERROR:  database "remocao" does not exist
DBNAME=# REVOKE ALL PRIVILEGES ON DATABASE "DBNAME" FROM dbuser;
REVOKE
DBNAME=# DROP USER dbuser;
DROP ROLE