15.10 - CREATE AUTHORIZATION and REPLACE AUTHORIZATION - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)

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