How to substitute the pass through comand for libname

[marcosemeao]

People,

How to substitute the pass through comand for libname

connect to oracle as myconn (user=smith password=secret
path='myoracleserver');

for libname sintax

[r_behata]

PROC SQL;    
  CONNECT TO ORACLE (user=user password="password" path=schema);
  CREATE TABLE LIBRARY.tab_nm AS
   SELECT *       
      FROM CONNECTION TO ORACLE          
       (
           <Your ORACLE SQL query here>
     	);
  DISCONNECT
  FROM ORACLE; 
 QUIT;

[marcosemeao]

thanks r_behata!

But I cant show my user and  password at code.

I need to have a way that my user and password can't  be seen by other users that can access my program.sas or log.

Regards

[Kurt_Bremser]

Then you have to make sure that only those with need-to-know have access to those files.

[r_behata]

Encoding the Password is one option.

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002595992.htm

[Reeza]

It's stage 1 & 2 here:
https://documentation.sas.com/?docsetId=bidsag&docsetTarget=p1t9q2knb9tq5ln101dkrdsa9ymf.htm&docsetV...

Yes, this is for data integration studio, but the idea is the same for a desktop here. Set up the ODBC connection (or whatever connection in user dsn) and then use a libname statement.

libname name8cha odbc schema="dbo" noprompt="server=XXXXXXX,YYYY;DRIVER=SQL Server;Trusted_Connection=yes;database=dbname";

That's an example of my connection string.

[AndreasWindisch · Accepted solution]

Hey,

if you use a environment with a Metadata Server (normally BI Server) you could use a Authentication Domain (libname option 'authdomain='). You will have to setup the library in the Metadata Server first, but that are a few steps.

This paper will give you a short overview (it is some days older, but the steps are the same until now).
http://support.sas.com/techsup/technote/ts771.pdf

Best regards,
Andreas

[marcosemeao]

I'm sorry for the delay in replying

My client uses connection in SQL.

CONNECT TO ODBC AS SQLCON
(DSN = BW_PROD USER = SRV_SASLayout PWD = "XXXXXXX%" READ_ISOLATION_LEVEL = 'RU');

Thanks for the tips and I'm reviewing what you have sent

I'll test the alternatives.

thankful