How to give admin on a role to another user/role in PostgreSQL
0
votes
1
answer
594
views
PostgreSQL - Version 16.4
I am trying to change the password of a user (xyz). I have logged in as abc. abc has ADMIN and CREATEROLE privileges. I am getting an error -
ERROR: permission denied to alter role
DETAIL: To change another role's password, the current user must have the CREATEROLE attribute and the ADMIN option on the role.
I guess this means abc must have ADMIN option on xyz. How can I find out which users/roles have ADMIN option on xyz? How can I grant ADMIN on xyz to abc?
Asked by Jayadevan
(1051 rep)
Oct 31, 2024, 10:27 AM
Last activity: Oct 31, 2024, 12:50 PM
Last activity: Oct 31, 2024, 12:50 PM