Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 07 Feb 2008 @ 21:49:01 GMT

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

Subj:   Re: DDL ( Show Table ) from DBC tables
From:   Anomy Anom

<-- Anonymously Posted: Thu, 7 Feb 2008 14:13 -->

Anomy.Anom wrote:

  How do we get the "Show Table" output from DBC tables? Our users do not have rights to do a "Show Table". Is there a way I can get the original CreateText from DBC tables ?  

The easiest way to do this is to allow users to run show table commands. We do not allow anyone direct access to base tables but we do allow everyone to perform SHOW TABLE on production tables. All a user needs in order to do this is some/any access privilege on the base table database. In our case we grant checkpoint on the base table database to every user. This allows them to run show table but they cannot select any tables directly. HELP TABLE is another handy command for end users that will show the columns of a table in the exact order that they appear in the table as well as the datatype and comment of each column.

  <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: 28 Jun 2020