17.10 - Restricting User Access with Macros and Stored Procedures - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Advanced SQL Engine
Teradata Database
Release Number
July 2021
English (United States)
Last Update

Macros and stored procedures are prefabricated routines that perform specific job functions in the database. You can grant the EXECUTE privilege on a macro or stored procedure to a user, and limit the actions the user can perform on a database object to those actions allowed by the routine.

Macros are useful for generating reports or repetitive data entry tasks, where the user only needs limited access to the database. You can construct macros to:
  • Allow the user to provide values for certain columns, for example name, address, and phone number in a personnel table, without being able to select other columns.
  • Gather data for reports without allowing the user to interact with the data.

You can construct stored procedures to perform complex tasks in the database, while the executing user has only the EXECUTE privilege on the stored procedure.

Related Information

For information on... See...
creating macros and stored procedures
  • Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
  • Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184.
using macros and stored procedures Teradata Vantage™ - Database Administration, B035-1093.
additional privileges required by users who execute macros or stored procedures on row level security tables