We're trying something a little different as way to get past some security restrictions, and I'd like to see if anyone has had any luck calling a workspace server macro from inside a stored process.
We have a requirement to not store libname credentials inside the metadata. We need to connect to DB2 using credentials that are shared by groups of users. In workspace server this can be done by referencing the calling user's unix username and then running a unix decrypt command in the sas.sh shell script that starts the workspace server. Our difficulty comes in trying to do the same thing from a stored process, since there is no way to identify the user at session startup. However, once the session starts we can set the username as a macro variable within the stored process. At this point we would need to connect to a workspace server and have it run the decrypt to establish the libname. (We cannot run it directly due to the noxcmd secuirty requirement).
Is there a way, from within a stored process, to connect to a workspace server to execute code?