16.00 - Creating an Authorization - Teradata Studio

Teradata Studio User Guide

prodname
Teradata Studio
vrm_release
16.00
created_date
March 2017
category
User Guide
featnum
B035-2041-126K
An authorization creates an association between a database user and an OS platform user identification, allowing external routines to run in secure mode using the context, privileges, and access control granted to the specified OS user. For more information about authorizations, see SQL Data Definition Language - Syntax and Examples. For information about the authorization trusted extensions that you use to access remote systems using QueryGrid, see the Teradata QueryGrid documentation.
  1. In the Navigator, right-click Databases and click Show Databases. A list of the databases and users in the connected system appears in the Object List Viewer. The list is filtered according to any filters you have applied.
  2. In the Object List Viewer, right-click the database or user for which you want to define an authorization, and click Show Authorizations. Any authorizations that have been defined for the database or user are listed in the Object List Viewer.
  3. In the Object List Viewer toolbar, click . A Create Authorization property form opens in the Details view.
  4. Enter the properties that define your new authorization.
  5. [Optional] Click the SQL category to see the SQL code that will be executed on the connected system to create the new authorization.
  6. Click Commit.
  7. Click OK. A property form shows the new authorization properties.