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

SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2023-04-27
dita:mapPath
xwv1596137968859.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1210
lifecycle
previous
Product Category
Teradata Vantage™

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.