To create or use a macro the following additional database privileges are required, which are granted by the owner of the database.
- The CREATE MACRO privilege.
- Access to the appropriate database elements. A user cannot create a macro to access a database table that the user does not have permission to access.