Creates or replaces an authorization object.
An authorization object associates a database user with 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 routines include UDFs, table UDFs, methods, and external SQL procedures.
- CREATE FOREIGN TABLE
- CREATE FUNCTION MAPPING and REPLACE FUNCTION MAPPING
- AUTHORIZATION clause of the READ_NOS and WRITE_NOS table operators (see SQL Operators and User Defined Functions)If an AWS IAM credential provides access, you can omit the AUTHORIZATION clause.
For information about the CREATE AUTHORIZATION trusted extensions that you use to access remote systems with QueryGrid, see your Teradata QueryGrid documentation.
Teradata Text Analytics AI Fast Path Functions can use CREATE AUTHORIZATION to establish a secure connection with a cloud platform using arguments. See Common Functionality or Rules.
ANSI Compliance
CREATE AUTHORIZATION is a Teradata extension to the ANSI SQL:2011 standard.
Required Privileges
You must have either the CREATE/REPLACE AUTHORIZATION or AUTHORIZATION privilege to use the CREATE/REPLACE AUTHORIZATION statement.
Privileges Granted Automatically
DROP AUTHORIZATION to the creator of the authorization.