17.10 - Resource Access - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

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

Java UDFs can access resources, such as local files, if required. The CREATE FUNCTION or REPLACE FUNCTION statement for the UDF determines which resources the UDF has access to.

IF the CREATE/REPLACE FUNCTION statement … THEN the UDF …
specifies the EXTERNAL SECURITY clause can access specific resources that require special permissions, in addition to accessing local files or performing actions that ordinary operating system users have permissions for.

Teradata uses a separate secure server to execute the UDF under the authorization of a specific native operating system user established by a CREATE AUTHORIZATION or REPLACE AUTHORIZATION statement.

does not specify the EXTERNAL SECURITY clause runs in protected execution mode and can access local files or perform actions that ordinary operating system users have permissions for.

Vantage executes the UDF as a thread of a hybrid server that runs under the authorization of the 'tdatuser' operating system user.

For more information on Java server administration, see Server Administration for Java External Routines.