READ_NOS Function Mapping | Teradata Vantage - 17.10 - Define a Function Mapping for READ_NOS - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1210-171K
Language
English (United States)

You can use function mapping to hide credentials in an authorization object. After you create the function mapping, you can use the mapped authorization object in queries and avoid exposing your credentials.

The user needs the following privileges to create an authorization object and a function mapping. Contact your administrative user for assistance

  • CREATE AUTHORIZATION privilege to create an authorization object
  • CREATE FUNCTION privilege to create a function mapping

You can define a function mapping for the READ_NOS function with the EXTERNAL SECURITY clause to include an authorization. You can also define a function mapping which includes the ANY IN TABLE clause for querying files without an extension.