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.
- 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.
|For information on...||See...|
|creating macros and stored procedures||
|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|