15.00 - Restriction on External Authorization From a Macro - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Restriction on External Authorization From a Macro

You cannot specify CREATE AUTHORIZATION in a macro (see “CREATE AUTHORIZATION/ REPLACE AUTHORIZATION” on page 206) because the authorization password is not saved in either encrypted or unencrypted form. This is because doing so would compromise the security of the OS logon user ID.

Otherwise, the system returns an error to the requestor.