You must have the CREATE TRIGGER system privilege to create a trigger on an object that
you own. If the object is owned by another user, you’ll need that user to grant you the
ALTER privilege on the object. Alternatively, the privileged user can grant you the ALTER
ANY TABLE and CREATE ANY TRIGGER privileges.
You have definer permissions on your own schema-level components, but you must have
EXECUTE permission when you call a schema-level component owned by another user.
-
Authors
punit
