Archives of the TeradataForum
Message Posted: Mon, 17 Sep 2001 @ 18:39:11 GMT
| Subj: || || Re: Lost use of some PC tools |
| From: || || Fred Pluebell |
The ODBC driver defaults to using "HELP DATABASE;" as the means of enumerating objects (for the point and click selection lists).
That requires at least one right (any right) on the database itself. One quick workaround is to GRANT some right that is effectively null
(e.g. DROP TABLE for a database with no tables or EXECUTE for a database with no macros).
An alternative (less desirable in my view) is to configure the ODBC driver options for each client. You'll need to check "No HELP
DATABASE" and consider "Use X Views". If you don't check "Use X Views", users will see a list of all tables & views in the system. If
you do check "Use X Views", it will be much slower but users will see only the objects on which they hold a right. Neither one limits the
list to objects from VMDB, though.