I'm trying to grant a role to a new user on my database: The publisher role. But when I try this query:
grant role publisher to ben, I get this error message:
Permission denied for ASSIGN ROLE. Try executing SHOW USER PRIVILEGES to determine the missing or denied privileges. In case of missing privileges, they need to be granted (See GRANT). In case of denied privileges, they need to be revoked (See REVOKE) and granted.
I don't understand what is the problem here. I'm confused. Can somebody clarify this? Thank you in advance.