16.20 - Resource Access - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
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 Database 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.

Teradata Database 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.