15.10 - authorization_name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

A name to be used for this authorization so it can be invoked within an external routine definition. See CREATE FUNCTION (External Form) and REPLACE FUNCTION (External Form), CREATE FUNCTION (Table Form), CREATE METHOD, and CREATE PROCEDURE and REPLACE PROCEDURE (External Form).

For information about naming database objects, see SQL Fundamentals, B035-1141.

The following rules apply to authorization names:
  • An authorization object name cannot begin with a digit.
  • An authorization object name cannot be an SQL keyword.
  • An authorization object name must be unique within its containing database or user.
  • The name of an authorization object must conform to object naming rules.
  • Authorizations belong to the database or user in which they are created and are not valid in other databases or users.
  • A database or user can be associated with only one INVOKER authorization object name.
  • A database or user can be associated with only one default DEFINER authorization object name.
  • A database or user can be associated with many non-default DEFINER authorization object names.
database_name
user_name
Optional name of a database or user other than the current or default in which the authorization being defined or replaced is to be contained.
The following rules apply to specifying DEFINER or INVOKER.
  • If you specify DEFINER, the database or user you specify must be the containing database or user for the UDF, table UDF, method, or external SQL procedure.
  • If you specify INVOKER, the database or user you specify must be the logon database or user for a user or profile.