15.10 - Authorization Attributes and Options - Teradata Administrator

Teradata Administrator User Guide

prodname
Teradata Administrator
vrm_release
15.10
category
User Guide
featnum
B035-2502-035K
 

Table 19: Authorizations Dialog Box Description 

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:

  • CREATE/REPLACE FUNCTION
  • CREATE/REPLACE FUNCTION (Table Form)
  • CREATE PROCEDURE (External Form)
  • 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.