With SET ROLE or SET SESSION AUTHORIZATION it's possible to elevate privileges to any database acccount, including superuser or cause database engine crash.
vulners.com/securityvulns/securityvulns:doc:11446