Hello,
I have created the Oracle library through Oracle server , linked to the authentication domain by creating a user with valid oracle account.
When I register a table it prompts for username and password , though I have mentioned the authentication domain as default login.
I am expecting to connect to the database without prompting for credentials.
Any help is appreciated!
Thanks
Mushy
There are probaly several ways of doing this, but I usually create a metadata group which carries this credentials (with the specific authdomain), and then you would be a member of this group.
@LinusH Thanks for the response.
Indeed thats how I have created as well. I have also added the oracle group with the special authentication in the library and gave all permissions.
But, when I try to register table it initially asks for credentials. Is there a setting or am i missing anything to directly authenticate withount prompting for credentials?
Thanks,
Mushy
I don't have access to such 9.4 environment, so I just f unsorted thoughts:
- make sure that you are logged in so you get a match for the desired metadata user (see bottom right corner - you don't want anything that says PUBLIC).
- Check the metadata server log if that gives any clues about the authentcation process
- Can you access the database using a regular libref using authdomain in SASApp?
- Can you "View data" from let's say DI Studio or EG?
Try reading through this SAS online doc Overview of Common Data Sources - its part of the SAS Data Administration Guide.
Hope this helps,
Ahmed
Hi @AhmedAl_Attar Thanks for the information and links. I am indeed following the same process to create the library. The mail question is to know why I am getting a prompt to enter credentials when I try registering a table or updating the metadata?
Have you faced such issue?
Thanks
Mushy
@gwootton Could you help me in fixing this issue:
Just to reply to your question. No, I never experienced being prompted for my credentials everytime I needed to register a table.
I would highly suggest you contact SAS Tech Support
They would be the best and fastest way for your resolution.
Hope this helps,
Ahmed
@gwootton Thanks for your time for responding.
I created a new server under server manager, updated the path with double quotes and associated with the correct machine.
I created a new user and updated the account with the auth domain mentioned in the server and correct oracle credentials.
I created a new library with the correct auth domain and schema , I added the above oracle user in authorisation and granted him all permissions .
now when I see the libname or try to register tables.. I get the prompt to enter username and password. After I enter the credentials I am able to successfully view the libname or register tables.
Let me know if you need more information.
Thanks
Mushy
@gwootton Indeed I messed with the credentials. Now I could register the tables without having to provide the credentials. Super thanks for your help:-)
Best Regards,
Mushy
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.