Archives of the TeradataForum

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

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

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.

Cheers,

Dave

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

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