15.10 - CREATE AUTHORIZATION and REPLACE AUTHORIZATION - 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

Purpose

Creates or replaces an authorization object.

Authorization definitions make an association between a database user and an OS platform user identification, allowing an external routine to run in secure mode using the context, privileges, and access control granted to the specified OS user. External routine is a generic term for UDFs, table UDFs, methods, and external SQL procedures. For information about the CREATE AUTHORIZATION trusted extensions that you use to access remote systems using QueryGrid, see your Teradata QueryGrid documentation.

Required Privileges

You must have either the CREATE/REPLACE AUTHORIZATION or AUTHORIZATION privilege to perform the CREATE/REPLACE AUTHORIZATION statement.

Privileges Granted Automatically

DROP AUTHORIZATION to the creator of the authorization.

Syntax