Can we create trigger on other schema table without create any trigger privilege
Hi,
Can we create trigger on other schema table without create any trigger privilege??
We have some triggers as:
CREATE OR REPLACE TRIGGER SCHEMA1.any_trigger
AFTER INSERT
ON SCHEMA2.any_table
FOR EACH ROW
DECLARE
On migrating this to new database not provided the create any trigger privilege to any schemas due to security reson.
But not able to create this type of triggers even though the object privileges are there to schema1 on schema2 objects.
Can anyone suggest on this, please??
Thanks,
Vishal.