seenukarthi [
https://community.jboss.org/people/seenukarthi] created the discussion
"Re: New-connection-sql Jboss"
To view the discussion, visit:
https://community.jboss.org/message/822453#822453
--------------------------------------------------------------
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
[
https://community.jboss.org/message/822453#822453]
Start a new discussion in Datasource Configuration at Community
[
https://community.jboss.org/choose-container!input.jspa?contentType=1&...]