|Date: ||Wed, 21 Oct 2009 14:51:19 -0700|
|Reply-To: ||adjgiulio <adjmost@COMCAST.NET>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||adjgiulio <adjmost@COMCAST.NET>|
|Subject: ||Netezza - hide password|
|Content-Type: ||text/plain; charset=windows-1252|
Iím using a libname statement to connect to a Netezza server through
LIBNAME ntz oledb init_string="Provider=nzoledb;
Initial Catalog=mycatalog;Data Source=mysource;" schema=myschema;
Whatís bothering me is that the statement seems to require my userid
and password, which obviously I donít feel comfortable leaving in my
code and I wouldnít want to delete and retype every time.
That was not the case for SQL.
LIBNAME sqlsrv oledb init_string="Provider=sqloledb;
Integrated Security=SSPI;Persist Security Info=True;
Initial Catalog=mycatalog;Data Source=mysource" schema=myschema;
Is there any way I can have SAS pull my Windows credentials instead of
having to type id and password in the libname statement?