Creating or replacing a trigger does not grant trigger-related privileges to either the creator or the immediate owner of that trigger.
You cannot grant privileges on a trigger, only on the database or table to which the trigger applies.
|To...||the user must have the...|
|create a trigger||
|replace a trigger||
|drop a trigger||DROP TRIGGER privilege on the subject table or the database containing the table|
|execute a trigger||privileges required for executing triggering statements.
In addition, the immediate owner of the trigger must have: