Sample Header Ad - 728x90

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