ALTER TRIGGER PRIVILIGE
761897Nov 22 2010 — edited Nov 22 2010Hi All,
I have triggers creating in one schema. I want to edit the triggers now and recompile them, but when I do this, it prompts to me INSUFFICIENT PRIVILEGES. I am able to edit and recompile the packages, procedures and function but not the triggers. How can I check whether I have the privilege to alter the trigger or not to the same schema. And if no privilege is there, then please let me know what is the command to give the PRIVILEGE for ALTER TRIGGER.
Thanks in advance