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

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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.