Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 17 Sep 2001 @ 19:30:48 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Lost use of some PC tools
From:   John Adams

Fred Plubell wrote:

  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).  

When I was shown this, the right I was taught to use was CHECKPOINT, which is of very little use or danger all by itself anywhere.

John A

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