15.10 - Overview - Teradata Administrator

Teradata Administrator User Guide

prodname
Teradata Administrator
vrm_release
15.10
category
User Guide
featnum
B035-2502-035K

Teradata Administrator provides a comprehensive Windows-based graphical interface to the Teradata Database Data Dictionary for performing a multitude of database administration tasks on the Teradata Database.

The following functions can be performed:

  • Create, Modify and Drop Databases, Users, Roles, Profiles, and User-Defined Types.
  • Create Tables (using ANSI or Teradata syntax)
  • Grant or Revoke access and system rights
  • Copy Table, View or Macro definitions to another database, or to another system
  • Drop or Rename Tables, Views or Macros
  • Move space from one database to another
  • Run an SQL query
  • Display information about a Database or Users
  • Display information about a Table, View or Macro
  • Set up the rules for Query and Access Logging
  • Teradata Administrator keeps a record of all the actions that are taken and can optionally save this record to a file. This record contains a time stamp together with the SQL that is executed, and other information such as the statement's success or failure.