Tools Menu

Teradata Administrator User Guide

Product

Teradata Administrator

Release Number

15.00

Language

English (United States)

Last Update

2018-09-27

dita:id

B035-2502

lifecycle

Product Category

Teradata Tools and Utilities

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 55.
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 72.
Create>Role	None	Create roles and assign users to them.	“Administer Roles” on page 67.
Create>Type	None	Create user-defined types.	“Administer User-Defined Types” on page 75
Create> Authorization	None	Create an authorization.	“Administer Authorizations” on page 69
Grant/Revoke> Object Rights		Grant or revoke general database access privileges to users or roles.	“Grant or Revoke Object Rights” on page 83.
Grant/Revoke> System Rights	None	Grant or revoke system privileges to users or roles.	“Grant or Revoke System Rights” on page 85.
Grant/Revoke> Logon Rights	None	Grant or revoke logon privileges to users.	“Grant or Revoke Logon Rights” on page 88.
Grant/Revoke> Column Rights	None	Grant or revoke column privileges to users or roles.	“Grant or Revoke Column Rights” on page 86.
Grant/Revoke> Connect Through	None	Grant or revoke connection privileges to users or roles.	“Grant or Revoke Connect Through Rights” on page 89
Administer> Profiles	None	Administer profile access.	“Administer Profiles” on page 72.
Administer>Roles	None	Administer database roles.	“Administer Roles” on page 67.
Administer> UDTs	None	Administer user-defined types.	“Administer User-Defined Types” on page 75
Administer> Authorizations	None	Administer authorizations.	“Administer Authorizations” on page 69
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 78.
Clone Database	None	Create a new database that is either identical or closely related to an existing database.	“Create or Modify Databases” on page 55.
Modify Database	None	Change the specifications of an existing database.	“Create or Modify Databases” on page 55.
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 91.
Move Space		Reallocate permanent disk space from one database to another.	“Move Space Between Databases” on page 81.
Query		Create, modify, test, and run SQL query scripts.	“Run or Explain a Query” on page 119.
Query Logging	None	Log SQL queries processed by a system.	“Work with the Query Log” on page 93.
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.