Database Access Prerequisites - Teradata Administrator

Teradata Administrator User Guide

Product
Teradata Administrator
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2502
Product Category
Teradata Tools and Utilities

The following access privileges are required to use the Teradata Administrator functions:

  • To use the viewing functions, Select access privileges are needed for the DBC views of the Teradata Database.
  • Note: A few reports require Select access to the base tables.

  • To use the Copy, Drop, Create or Grant tools, the corresponding privilege is needed on the table or database that is being modified or created.
  • To use the Browse or Row Count features, Select access privileges are needed to the Table or View.
  • For more details about the access right for specific tables and views, refer to the setup.sql file in the SQL sub-directory of the Teradata Administrator installation directory. This file also contains instructions for the use of an alternate 'restricted access' control file, which limits users to only those items they can access using X view.