Explanation
You tried to use a SET statement to activate a role which requires you to specify a password.
User Response
Repeat the SQL statement, specifying the password this time.