15.10 - Tools Menu - Teradata Administrator

Teradata Administrator User Guide

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

Use the Tools menu to perform database maintenance and administration functions.

Note: The Options command is the only command available on the Tools menu until a connection is established with a database server.

 

Table 6: Tools Menu Commands 

Command

Button

Description

Additional Information

Create > Database

Create an entirely new database, with no shared specifications from an existing database.

“Create or Modify Databases” on page 54.

Create > Table

None

Create a new table.

“Create Tables” on page 56.

Create > User

Create an entirely new user, with no shared specifications from an existing user.

“Create or Modify User Accounts” on page 51.

Create > Profile

None

Create database profiles and assign users permissions to use them.

“Administer Profiles” on page 69.

Create > Role

None

Create roles and assign users to them.

“Administer Roles” on page 65.

Create > Type

None

Create user-defined types.

“Administer User-Defined Types” on page 72

Create > Authorization

None

Create an authorization.

“Administer Authorizations” on page 67

Grant/Revoke > Object Rights

Grant or revoke general database access privileges to users or roles.

“Grant or Revoke Object Rights” on page 81.

Grant/Revoke > System Rights

None

Grant or revoke system privileges to users or roles.

“Grant or Revoke System Rights” on page 83.

Grant/Revoke > Logon Rights

None

Grant or revoke logon privileges to users.

“Grant or Revoke Logon Rights” on page 86.

Grant/Revoke > Column Rights

None

Grant or revoke column privileges to users or roles.

“Grant or Revoke Column Rights” on page 84.

Grant/Revoke > Connect Through

None

Grant or revoke connection privileges to users or roles.

“Grant or Revoke Connect Through Rights” on page 86

Administer > Profiles

None

Administer profile access.

“Administer Profiles” on page 69.

Administer > Roles

None

Administer database roles.

“Administer Roles” on page 65.

Administer > UDTs

None

Administer user-defined types.

“Administer User-Defined Types” on page 72

Administer > Authorizations

None

Administer authorizations.

“Administer Authorizations” on page 67

Administer > Security Constraints

None

Administer security constraints. This feature only appears when connected to Teradata Database 14.0 or above.

“Manage Security Constraints” on page 76.

Clone Database

None

Create a new database that is either identical or closely related to an existing database.

“Create or Modify Databases” on page 54.

Modify Database

None

Change the specifications of an existing database.

“Create or Modify Databases” on page 54.

Clone User

None

Create a new user either identical or closely related to an existing user.

“Create or Modify User Accounts” on page 51.

Modify User

None

Change the specifications of an existing user.

“Create or Modify User Accounts” on page 51.

Access Logging

None

Start or stop access logging for specific tables, databases or users, or view currently defined Access Log Rules.

“Work with the Access Log” on page 89.

Move Space

Reallocate permanent disk space from one database to another.

“Move Space Between Databases” on page 78.

Query

Create, modify, test, and run SQL query scripts.

“Run or Explain a Query” on page 115.

Query Logging

None

Log SQL queries processed by a system.

“Work with the Query Log” on page 91.

Options

None

Configure the operational preferences for Teradata Administrator.

  • “Step 2a - Set Database Options” on page 35.
  • “Step 2b - Set Filtering Options” on page 36.
  • “Step 2c - Set Confirmation Options” on page 36.
  • “Step 2d - Set Browse Options” on page 38.
  • “Step 2e - Set General Options” on page 38.
  • “Step 2f - Set the Data Directory” on page 39.