Object owner

[bryan]

Hi,

Hope someone can hep me here. I have a trigger that will be copied, along
with the source table to many other schemas. Users then come along and edit
the table, causing the trigger to fire, and copies data into a central table.
The problem is that due to the restrictions I have placed upon me I canot
identify with owner the records have come from (all will be from the same
table name). Therefore I need to identify within the trigger which schema
it currently belongs to.

The unique combintion will be owner and trigger name, but I will not know
before the trigger fires which schema will own the trigger. I do not want
the user who performs the edit, I need the schema name, and this means that
all_objects amd all_triggers are out (unless I can somehow get the object_id)

To me it sees as though it should be easy to find which schema owns an object,
and this is the case if the object name is unique, but how do you do this,
if in my case it is the ownser.object name that is unique

Thanks

Bryan