The Explorer window will not display a complete list of tables that are
accessible by the user. This occurs even if the schema= option is
defined on the LIBNAME statement.

This is a Teradata issue because SAS/Access to Teradata calls a Teradata
restricted view to generate the list.

It is important to note that this in no way denies access to the
Teradata tables, provided the user has the appropriate access
privileges. It only causes an incomplete viewable list to be generated.

In order to fix this issue, the Teradata view DBC.TablesX must be
manually edited by the site's Teradata DBA.

This is the section of the view to be edited

Original:


   WHERE  tvm.DatabaseId = dbase.DatabaseId
   AND    tvm.tvmid IN
          (/* IDs of tables accessible to the USER */
          SELECT tvm.tvmid
          FROM   TVM, DBASE, ACCESSRIGHTS, OWNERS, ROLES
          WHERE    tvm.tvmid <> '000000000000'xb
          AND      dbase.DataBaseNameI = USER

Edited:

   WHERE  tvm.DatabaseId = dbase.DatabaseId
   AND    tvm.tvmid IN
          (/* IDs of tables accessible to the USER */
          SELECT tvm.tvmid
          FROM   TVM, DBASE, ACCESSRIGHTS, OWNERS, ROLES
          WHERE    tvm.tvmid <> '000000000000'xb
          /* Commented out                       */
          /* AND      dbase.DataBaseNameI = USER */

Operating System and Release Information