Given the following Oracle proxy user grant alter user service-account-name grant connect through personal-account-name; how might one establish a connection to an Oracle database using "personal-account-name[service-account-name]" as the user name in SAS? I don't have access to SAS myself but I work with people who do which makes it difficult for me to diagnose issues with Oracle proxy user access from within SAS. The only person I worked with so far could not get it to work. So I am trying to understand if SAS is capable of seeing and using the "[service-account-name]" clause in the user name field. I think the following is a valid example. proc sql; connect to oracle as myconn (USER='personal-account-name[service-account-name]' PASSWORD='personal-account-password' PATH='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WhateverHost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=WhateverServiceName)))'); select * from connection to myconn (select sys_context('USERENV','PROXY_USER') PROXY_USER, sys_context('USERENV','SESSION_USER') SESSION_USER from dual); disconnect from myconn; quit; Thank you.
... View more