Creating an Authorization - 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
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.