topic Re: SAS DI Libname issue: not able to register oracle table in SAS Data Management

SAS DI Libname issue: not able to register oracle table

sas_pkc1 — Tue, 07 Mar 2017 08:11:28 GMT

Dear All,

I created libraries in SMC and registered tables from oracle, but i am not able to register some tables which are present into oracle from SAS DI.

at the time of register for tables in SAS DI its showing for AUTHDOMAIN username and password not assigned

Please help.

i have SAS personal login manager, is there anything which i need to do in it?

Thanks

Re: SAS DI Libname issue: not able to register oracle table

JuanS_OCS — Tue, 07 Mar 2017 09:08:03 GMT

Hello @sas_pkc1,

they problem I expect is that your user is not in the group that contains the user to connect to your Oracle database. Once you are in, disconnect from DI, connect again and try again.

You can read the following SAS post, I think it can be useful to you:

http://blogs.sas.com/content/sasdummy/2010/11/23/five-strategies-to-eliminate-passwords-from-your-sas-programs/

Re: SAS DI Libname issue: not able to register oracle table

sas_pkc1 — Tue, 07 Mar 2017 11:03:23 GMT

Dear juan S_OCS,

issue resolved, thank you so much, i created groups and added user to that group for oracle connection.

Thanks.

Prashant.

Re: SAS DI Libname issue: not able to register oracle table

JuanS_OCS — Tue, 07 Mar 2017 15:45:00 GMT

@sas_pkc1, glad that it helped a bit and you got it working.

Re: SAS DI Libname issue: not able to register oracle table

AnnaBrown — Tue, 07 Mar 2017 16:16:17 GMT

Hi sas_pkc1,

I'm glad you found some useful info! If Juan's reply was the exact solution to your problem, can you "Accept it as a solution"? Or if it was helpful, feel free to "Like" it. This will help other community members who may run into the same issue know what worked.

Thanks!
Anna