AWS Redshift and Oracle impersonate another user (requires superuser permissions) with set session authorization

set session authorization ‘username’;

SET SESSION AUTHORIZATION – Amazon Redshift

BTW – you can do this with Oracle too I believe with:

alter session set current_schema = <username>;