>I gave all privileges to the trigger on its table but that did not help.

What do you mean by 'its table'? Grant the trigger rights to the table it should insert/update, e.g.

GRANT ALL ON TABLE1_PRIVILEGES TO <trigger>;

HTH,
Set