This should work, I tried someting similar
<new-connection-sql>
BEGIN EXECUTE IMMEDIATE 'SET ROLE RL_USER_SELECT IDENTIFIED BY RL_USER_SELECT'; EXECUTE IMMEDIATE 'RL_ACCESS_CONSULT IDENTIFIED BY RL_ACCESS_CONSULT'; END;
</new-connection-sql>
Reply to this message by going to Community
Start a new discussion in Datasource Configuration at Community