Macros | Privileges Needed for Database Administration | Teradata Vantage - Macros - Teradata Vantage - Analytics Database

SQL Data Control Language
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
sgu1628111251052.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dvv1472243528022
lifecycle
latest
Product Category
Teradata Vantage™
Goal Privilege User Needs
Create macro CREATE MACRO privilege on the database or user in which the macro is to be created. The creator automatically gets the DROP MACRO and EXECUTE privileges WITH GRANT OPTION.

The immediate owner of the macro is the containing database of the macro, not the user who created the macro. The immediate owner determines the macro access privileges, not the macro. The immediate owner must have all the appropriate privileges for executing the macro, including WITH GRANT OPTION.
Drop macro DROP MACRO privilege on the macro.
Rename macro DROP MACRO privilege on the macro.

In addition, the user renaming a macro must have the privileges for all statements the macro performs.
Run macro EXECUTE privilege on the macro.

In addition, the immediate owner of the macro (the database in which the macro resides) must have the necessary privileges on objects named in the request set for statements that are contained in the macro.
Replace macro
  • Privileges for all statements the macro performs
  • Privileges that depend on whether the macro being replaced already exists.
    • If the macro already exists, the DROP MACRO privilege on the macro or its containing database or user.
    • If the macro does not already exist, the CREATE MACRO privilege on the macro or its containing database or user
After a macro has been replaced, its immediate owner is its containing database, not the user who replaced it. The immediately owning database must have all the appropriate privileges for executing the macro, including WITH GRANT OPTION.
Delete macro DROP MACRO privilege on the specified macro