Archives of the TeradataForum
Message Posted: Thu, 07 Feb 2008 @ 21:49:01 GMT
| 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.
| 
