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