Usage Note 11914: Complete list of Teradata tables not being displayed in Explorer window
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
| SAS System | SAS/ACCESS Interface to Teradata | Solaris | 9 TS M0 | |
| 64-bit Enabled AIX | 9 TS M0 | |
| 64-bit Enabled HP-UX | 9 TS M0 | |
| HP-UX | 9 TS M0 | |
| 64-bit Enabled Solaris | 9 TS M0 | |
| AIX | 9 TS M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | low |
| Topic: | SAS Reference ==> LIBNAME Engines Data Management ==> Data Sources ==> External Databases ==> Teradata
|
| Date Modified: | 2004-04-08 18:04:35 |
| Date Created: | 2004-03-04 12:27:16 |