Authorization

To control authorization, you can use the SET statement.

SET PASSWORD

This statement allows to change connection credentials, but does not perform a  re-authentication:

SET PASSWORD 'someval';;

SET SESSION AUTHORIZATION

This statement performs a reauthentication given the credentials currently set on the connection:

SET SESSION AUTHORIZATION 'newuser';;