Hello all, 1 machine SAS 9.4 M8 install, one specific issue seen
Issue: SAS Meta ODBC data libraries established, (Oracle & DB2, lets called them db2 & ora data libraries, all using their own AuthDomain and CLI and odbc.ini are set). The issue is in EG is the library db2 or ora is expanded no tables appear. However, the relevant LIBNAME when run successfully execute and tables appear.
Checks done:
Checked for user's privilege and permissions OS, DB grants, and Metadata permission) all valid and at minimum have RM and read
Checked effective permissions in Metadata > Authorization > Advanced > Explore Authorization for the user = look good as expected.
Data server assignments of connection server and data library all look okay.
Anyone has any idea what else I could look at?
TIA
S
... View more