external_security_clause - Advanced SQL Engine - Teradata Database

Specifies authorization for accessing remote storage. See CREATE AUTHORIZATION and REPLACE AUTHORIZATION. You can specify the DEFINER option to share an authorization object with multiple users of the database in which it resides. You specify the INVOKER option to allow exclusive access by a user.

DEFINER TRUSTED

You can create the authorization in any database. You must create the authorization as DEFINER TRUSTED.

See Example: Specifying a Definer Authorization for a Foreign Table.

TRUSTED

INVOKER TRUSTED

You must create this authorization in the current user's database.

See Example: Specifying an Invoker Authorization for a Foreign Table.

authorization_name

Name of authorization.