New answers tagged postgresql-9.4
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 ...
- 101
Top 50 recent answers are included