Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 17 Sep 2001 @ 18:39:11 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023