Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 12 Apr 2011 @ 13:34:50 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: How to find list of database objects in teradata.
From:   DWellman

Hi Mandar,

You are correct, views such as dbc.tables, dbc.indexes etc are the usual way for finding out what objects exist on a Teradata system (whether you execute queries against these views directly or using a tool such as Teradata Administrator).

In order to execute a query against those views then the user needs to have access to them - this is the same as for any view in Teradata. If your userid does not have access to those views then you cannot query them - Teradata uses a 'closed' security system, if your userid does not have the required accessright to execute a command then you cannot execute it.

However, in a Teradata environment there are a number of ways that a userid can gain access to these objects:

- the user can explicitly be granted access to the object.

- the user can be granted access to a Role which has the necessary accessrights

- the necessary accessright may be granted to Public. Any accessright granted "to public" is available to all users defined to Teradata, both existing users and users created in the future.



Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

  <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