credentials in project?

[tomrvincent]

Anyone hear of a way to embed credentials in a project?  Instead of having libname or connect statements in programs within a project, can you somehow embed userid and password somewhere else in it?  Never heard of it and a contractor in a different departments claims to have done this.  I'm running EG7.1.

[ballardw]

May want to describe exactly what the credentials are supposed to do. And check that the "contractor" is using credentials for the same purpose.

Proc HTTP might include credentials.

Filename FTP or URL might.

Information could be stored in a data set and data step code uses that information with something like Call Execute so you don't see the "credentials" in the code but the program generates statements on the fly for libname or connect strings.

[tomrvincent]

As I said, no libnames/connects are in programs and the contractor claims they are in the projects themselves. I'm getting the info 2nd/3rd hand so that's very helpful and the contractor is out the door as of last week...no documentation, no validation that any of the projects work. I suspect they were developed with a different version of EG as well.

Fun and games in corporate life.

[SASKiwi]

One way to do this is to use Authentication Domains that are defined in SAS metadata. The Authdomain links to a service account / password combination also stored in SAS metadata and any LIBNAME just needs to specify the AUTHDOMAIN option instead of supplying a user account and password. 

[tomrvincent]

Thank you. I will look into that and see if that works out.