Pre-Assigned Library Appears in SAS EG, Registered Tables Do Not

[shoin]

Hi, no it was done by a user w' sas administrators group membership.

We checked the TLS setting on the compute server, it was at 1.2, target DB is sql server 2016, so we downloaded the MS SQ Sever driver (17) that supports.  The connection was successful.

1. The user testing ran a libname against it was able to see tables.  I need to check if registered tables appeared in SMC.  However, in a new EG session the same user if expands the said library, sees table but could not access.  The setup is very simple. 
2. 0 custom groups. 
3. permissions are SASUSERS > RM. 
4. Library is set w native engine
5. No autoexec no hidden config. Zilch. 
6. Target DB set w NT authentication/AD so everyone is using their own set of credentials. 
7. Also it is ACCESS/MS SQL SRVR module. 
8. SYS DSN test to target DB also successful.

Like to jump off the first floor.

[Sajid01]

Hi, no it was done by a user w' sas administrators group membership.
Hope they don't have the unrestricted permission.

[shoin]

🙂 no, member sas admin group

[Sajid01]

Try registering the tables with sasdemo account.

[shoin]

After some further investigation turned out there was schema error, relevant schema was not chosen for the library.  Once we obtained the schema listing of all tables in a DB and identified what was relevant, we were okay.

TY all for your kind help.

S