Hook procedures can be created by any user with the MANAGE REPLICATION system privilege. However, to ensure that the hook
can access the #hook_dict table, which is used to pass information in and out of hooks, hooks must meet one of the following
Be owned by a user with the SELECT ANY TABLE and UPDATE ANY TABLE system privileges.
Be defined using the SQL SECURITY INVOKER clause of the CREATE PROCEDURE statement.