Example: Creating an INVOKER Authorization Explicitly

This example creates an INVOKER authorization object with the name sales for the user name sam johnson and the user password tercesym, specifying AS INVOKER TRUSTED (the default).

CREATE AUTHORIZATION sales 
AS INVOKER TRUSTED
USER 'sam johnson'
PASSWORD 'tercesym';

The system uses this OS platform user context to run all external routines that contain an EXTERNAL SECURITY INVOKER clause when invoked by the database user that created this authorization.

Example: Creating an INVOKER Authorization Explicitly - Teradata VantageCloud Lake

Lake - Working with SQL