Modifying Database Objects - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
15.12
Published
August 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
cev1468860002862.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities

Many object types, including Profiles, Roles, Foreign Servers, and Secure Zones, can be modified using the following process:

  1. In the Administration perspective, right-click a database or user in the Navigator tree and select the applicable Show action for the object you want to modify. A list of those types of objects contained in the selected database or user appears in the Object List Viewer.
  2. In the Object List Viewer toolbar, right-click the object you want to modify and select the applicable Modify action for the object you want to modify. A property form for the selected object opens in the Details view.
  3. In the property form for the new object, modify the properties you want to change.
  4. [Optional] Click the SQL category to view the SQL DDL.
  5. Click Commit to modify the object according to the settings you changed.