topic SAS EG Unique issue. Data libraries visible to one and not to other for 2 identical users in Administration and Deployment

SAS EG Unique issue. Data libraries visible to one and not to other for 2 identical users

shoin — Mon, 31 Oct 2022 17:53:55 GMT

I am a bit stumped. Two end users, same AD group, SAS user groups, same roles and privileges (checked and triple checked setup and profiles of the two users). User A could see a couple of SAS Data libraries (Data_db1 & Data_db2), whereas user B could not. User B only has in EG the default SAS libraries. Both users are able to login.

Please suggest where do I look further.

Data_db1 & Data_db2 are SQL DBs nothing fancy and use service IDs to access.

I have asked to enable client side logging for EG and waiting to receive it.

NOTE: User B (having issue) could run the same LIBNAME string from "Display Libname" taken from SAS meta, no issue at all. COuld access underlying tables as well. Only, the same Data libraries do not appear in their EG session. Nothing in Authorization, or Extended properties that differ b/w user A and B. #grr

TIA

-S

Re: SAS EG Unique issue. Data libraries visible to one and not to other for 2 identical users

SASKiwi — Mon, 31 Oct 2022 19:01:14 GMT

Just to be clear, if user B runs the LIBNAME and refreshes the EG server list then the library and tables are listed? If so then this is definitely a SAS metadata inconsistency between the two users. Also for user B are both the library and tables are missing from the server list and not just the tables when using the metadata libraries?

Re: SAS EG Unique issue. Data libraries visible to one and not to other for 2 identical users

shoin — Mon, 31 Oct 2022 20:03:28 GMT

Thank you for your time and reply.

Partial answer.

Yes the library (& table) just do not appear

I will update with what I find after running libname --> refresh whether library/table appear.

-S

Re: SAS EG Unique issue. Data libraries visible to one and not to other for 2 identical users

Sajid01 — Sun, 06 Nov 2022 18:33:00 GMT

If both are have the same roles and privileges, it is possible that one of them must be a member of some additional groups . Please check for this.

Re: SAS EG Unique issue. Data libraries visible to one and not to other for 2 identical users

shoin — Thu, 10 Nov 2022 18:44:58 GMT

Sorry for the late update. We re-installed EG (doesn't make sense) and miraculously the libraries appear.; gasp! Yep. I did not buy. I have a feeling the genius was logging on to a wrong env. (dev) but face saving is an art ...

TY all and apologies for wasting your time.

-S