Answers for "remove role from user postgres"

SQL
1

delete user postgres

DROP USER [ IF EXISTS ] name [, ...]
Posted by: Guest on January-09-2021
0

unable to delete a role in postgres

REASSIGN OWNED BY ryan TO postgres;  -- or some other trusted role
DROP OWNED BY ryan;
-- repeat in ALL databases where the role owns anything or has any privileges!

DROP USER ryan;
Posted by: Guest on July-08-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language