Tools Menu - 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

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.