Restricting User Access with Macros and Stored Procedures - Analytics Database - Teradata Vantage

Security Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-04-05
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572
lifecycle
latest
Product Category
Teradata Vantage™

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 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 run macros or stored procedures on row level security tables