How to configure library as a Connection to Oralce and/or MS SQL database ins SAS Viya 4 similar to SAS 9.4 (nice and clear way to manage connections and users/groups).
I am not interested in CAS.
found these sources:
https://documentation.sas.com/api/collections/sasadmincdc/v_044/docsets/evfun/content/evfun.pdf?loca...
https://communities.sas.com/t5/SAS-Communities-Library/Where-to-define-your-SAS-libraries-in-SAS-Viy...
Able to connect to Oracle DB using libname statement and able to add resource in the SAS Studio session, see this as a resource in environment manager contexts, SAS Studio compute context , so the library populates when user (that configured connection) starts SAS Studio Session.
I am trying to configure access using identities option in the Edit Compute Context and add/assign libraries and grant access to these based on user/groups . I need to have an alias way to give users access to data sources, so the users do not see any DBs login data and manage users access based on groups.
Able to connect as the user that have access to the library in context configuration, but now all other users have SAS Studio compute context failing.
What I am missing; is this "normal" for this environment to be so unstable all this "close/open different browsers" business is a new standard or deployment is bad ?
Thank you.