further question on object owner

Hi,

I'll go a bit more into the problem I posted last week.

I have a table that will be copied into varying other accounts along with a trigger. A different account (user acount this time) will then change the table and activate the trigger causing various data to be copied into a central table. As the trigger will be owned by different acounts, I need to know which account the trigger belonged to when fired, not the user account that is changing the table. I will not the know which account the trigger has been copied to as the user can cal this anything they want, I will however know the table name.

So can anyone please help me, as I'm sure this is easy

Thanks

Bryan

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net