How to delete a role in Postgres #27427
TheOtherBrian1
announced in
Troubleshooting
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Quote from postgres docs:
First you must reassign any objects owned by role:
Once ownership is transferred, you can run the following query:
DROP OWNED BY does delete all objects owned by the role, which should be none. However, it also revokes the role's privileges. Once this is done, you can just run
DROP role <role that you want to delete>
Beta Was this translation helpful? Give feedback.
All reactions