New answers tagged

0 votes

Why am I getting permission denied on an ownership change?

A variation of the great answer by @OtoShavadze: mydb=> GRANT admin TO <current_user>; GRANT ROLE mydb=> GRANT new_admin TO <current_user>; GRANT ROLE mydb=> REASSIGN OWNED BY ...
user avatar

Top 50 recent answers are included