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.
|For information on...||See...|
|creating macros and stored procedures||
|using macros and stored procedures||Database Administration.|
|additional privileges required by users that execute macros or stored procedures on row level security tables|