|To...||the user must have the...|
|create a macro||
CREATE MACRO privilege on the database or user in which the macro is to be created. The creator automatically gets the DROP MACRO and EXECUTE privileges WITH GRANT OPTION. The immediate owner of the macro:
|drop a macro||DROP MACRO privilege on the macro.|
|rename a macro||DROP MACRO privilege on the macro.
In addition, the user renaming a macro must have the privileges for all statements the macro performs.
|execute a macro||EXECUTE privilege on the macro.
In addition, the immediate owner of the macro (the database in which the macro resides) must have the necessary privileges on objects named in the request set for statements that are contained in the macro.
|replace a macro||
Once a macro has been replaced, its immediate owner is the database in which it exists, not the user who replaced it. The immediately owning database must have all the appropriate privileges for executing the macro, including WITH GRANT OPTION.
|delete a macro||DROP MACRO privilege on the specified macro|