SAS DI Libname issue: not able to register oracle table

[sas_pkc1]

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

[JuanS_OCS · Accepted solution]

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-sa...

[sas_pkc1]

Dear juan S_OCS,

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

Thanks.

Prashant.

[JuanS_OCS]

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

[AnnaBrown]

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