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!
@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?
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?
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?
@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.
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.