How do I utilize user credentials from SAS Stored Process Web Application in a Stored Process?

[JordanS]

Hello,

I have a custom HTML form that is running a stored process that is stored on a SAS Stored Process Web Application server. Currently, the stored process gets user names and passwords from the user's Personal Login Manager; however, I would like to get away from doing that as the user has to authenticate with the SAS Stored Process application server after submitting the custom web form anyway. Is there anyway to use the credentials from the authentication to the web server rather than the Personal Login Manager in the stored process?

The stored process connects to other servers and databases and needs the username and passwords to connect.

Thanks,

Jordan

[boemskats]

Jordan,

I'm not sure if I have understood you correctly, but if you define the connections to your other servers and databases in SAS Metadata and use something like the metadata libname engine for your external connections, you should be able to use metadata security to allow or deny individual users access to the connections, and provide individual passwords for authentication domains which should be picked up automatically serverside by metadata. This would be managed by the PLM I think.

For me the best feature of the sas stored process web app is that each stored process execution automatically inherits the authenticated metadata context of the user the STP executed as. Have you tried this approach? Or are you saying that that's exactly what you'd like to avoid doing? 

Nik