You are logged on to the database as a database user.
You are the owner of the table for which the database trigger is defined.
The database is in the ONLINE operational state.
SQL Reference Manual, DROP TRIGGER Statement (drop_trigger_statement)