Authorization Attributes and Options - Teradata Administrator

Field or Control Name

Description

Database Name

Use this list to specify the database or user for this authorization.

Authorization Name

Enter the name of the authorization.
It cannot be the same as a table, view, or macro name.

Definer

This keyword associates an operating system user to the Teradata Database that contains an external routine.

If Definer is specified, then the Database Name must be the containing database for the external routine.

Invoker

This keyword associates an operating system user to the database user who invokes an external routine.

If Invoker is specified, then the Database Name must be a Teradata user.

Only one Invoker authorization name can be assigned per database.

Default

An optional keyword modifier for the DEFINER keyword that associates this authorization with all external routines that do not specify the authorization name in the EXTERNAL SECURITY DEFINER clause of the following statements:

Only one default DEFINER can be assigned per database.

If a default Definer already exists for the specified database, the CREATE AUTHORIZATION request fails.

Domain

Enter the domain name for the user.
This applies only to Teradata Databases running on Windows.

User Name

Enter the name of an operating system user that is defined on every node of the system. Must be a member of the tdatudf user group.

Password

Enter the password of this operating system user.

Note: Type the complete password. Do not use the Paste command. Do not use the arrow keys or the mouse to navigate in this field.

Comment

Enter an optional comment to describe this Authorization object.