16.10 - Restricting User Access with Macros and Stored Procedures - Teradata Database

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K

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
  • SQL Data Definition Language Syntax and Examples.
  • SQL Data Definition Language Detailed Topics.
using macros and stored procedures Database Administration.
additional privileges required by users that execute macros or stored procedures on row level security tables