Desktop productivity for business analysts and programmers

Libraries visible as admin in SAS Studio and Manag. Console but not EG

Accepted Solution Solved
Reply
Contributor
Posts: 71
Accepted Solution

Libraries visible as admin in SAS Studio and Manag. Console but not EG

Dear SAS Pros,

I created a few BASE auto-assigned libraries using Management Console.

I can see all of them there and in SAS DI Studio BUT not in EG. Yes, I tried to refresh and re-connect but they are still not there.

I have declined the user PUBLIC all rights on the libraries but created a new user group "libusers" who have total access to those libraries. But...none of them can see those. As admin I can see at least half of them in EG but still not all.

Any ideas why that might be?

Many thanks for any insight and a great weekend!


Accepted Solutions
Solution
‎02-27-2017 03:29 AM
Super User
Posts: 3,233

Re: Libraries visible as admin in SAS Studio and Manag. Console but not EG

A good test is to try the libraries that are not working in LIBNAME statements and submit these in EG - do they assign without error?

View solution in original post


All Replies
Super User
Posts: 7,386

Re: Libraries visible as admin in SAS Studio and Manag. Console but not EG

Also check if the EG users have physical access to the libraries on the operating system level.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Solution
‎02-27-2017 03:29 AM
Super User
Posts: 3,233

Re: Libraries visible as admin in SAS Studio and Manag. Console but not EG

A good test is to try the libraries that are not working in LIBNAME statements and submit these in EG - do they assign without error?

Contributor
Posts: 71

Re: Libraries visible as admin in SAS Studio and Manag. Console but not EG

Hi KurtBremser,


Thanks for your reply. I asked the SAS unix server admin to confirm this.
@SASKiwi. Good idea. What I find odd is that even as user with admin rights I cant see all libnames
in EG but I see all of them in the management console and SAS DI Studio.

I created the following libraries:
EFSA
PSM
ZOONOSEN
MONITOR
BUEP*
CHEMKONT*

The two with the * I couldnt see in EG as user with admin rights.
I checked the unix path and noticed it was wrong.

Now the only issue left is that users without admin rights cant see any of those.
Users who I specifically moved in a new group that has all rights to those libraries.

I generated a libname to test with PSM:

LIBNAME PSM BASE "/sas_data/xxx/xxx/PSM";
and interestingly that worked well for all users. I wonder now...why is this normally auto-assigned
library (as are the other 5 not seen by non-admin users straight away? I dont need that everyone runs a libname every time they start EG.



Contributor
Posts: 71

Re: Libraries visible as admin in SAS Studio and Manag. Console but not EG

[ Edited ]

The new group I created has read/write access to the metadata folder /sas_data/xxx/xxx/

Super User
Posts: 7,386

Re: Libraries visible as admin in SAS Studio and Manag. Console but not EG

What you see in SAS MC is a logical definition of a library. If you have the correct authorization in metadata you can work with the definition, but if the proper operating system permissions are missing, you can't execute the libname statement successfully.

Users being able to see a library in metadata, but not being able to access the library from EG, points to this.

I use this deliberately. My autoexec_usermods.sas file for the workspace server %includes the company-wide libname.sas file that contains all library definitions; only the ones allowed by the OS for a specific user will execute successfully during workspace server startup and will appear in the user's server list in EG.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 71

Re: Libraries visible as admin in SAS Studio and Manag. Console but not EG

Got it:

" If you have the correct authorization in metadata you can work with the definition" -> I indeed forgot to set all the permission right.
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 212 views
  • 2 likes
  • 3 in conversation