Dear all,
I have a trigger on a table in schemaA.I have grant all on table to schemaB. If I login with schemaB, I was not able to disable the trigger of schemaA. It gave the error,
ORA-04080: trigger 'blah_blah' does not exist
Please help me out. I will explain the problem in detail below.
I'm running a flow in Informatica powercenter with a different user from the target table schema owner. I should use a batch user to run the flow which is not the owner. But I want to disable the trigger on the table before I perform the flow and that can be handled using pre SQL in Power Center Designer. But when I ran the flow, I got this error. I tried it even in SQL*Plus by logging in as schemaB and tried to disable. I got this error. Is there anyway out of this?
If the problem gets solved by granting some permissions to schemaB, I'm ready for that. I want gurus to help me out. Is there something called
GRANT DISABLE TRIGGER ON trigger_name TO target_user
Cheers
Deepa