Example: Creating a DEFINER Authorization - Teradata Vantage

This example creates a default definer authorization with the name accounting in the SYSLIB database for the client user name accdept and user password nesuahkcotsk.

All external routines in the SYSLIB database that contain an EXTERNAL SECURITY DEFINER clause are run using the user context defined by this request.

If the SYSLIB database already has a default definer authorization, trying to create another one causes an error.

CREATE AUTHORIZATION SYSLIB.accounting 
AS DEFINER DEFAULT TRUSTED
USER 'accdept'
PASSWORD 'nesuahkcotsk';