Additional Database Privileges for Macros

Basic Teradata Query Reference

brand
Teradata Tools and Utilities
prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

To create or use a macro the following additional database privileges are required, which are granted by the owner of the database.

  • The CREATE MACRO privilege.
  • Access to the appropriate database elements. A user cannot create a macro to access a database table that the user does not have permission to access.