Hi all,

Does any body know how to find out all the objects created by particular session id in current session?

This is what I'm trying to achieve. I would like to bypass a trigger (ie. stop the trigger to be fired) for the current session (ie. doesn't affect other session from using the trigger).

Then if I find out a temp table is created. Then I would like the temp table to be deleted as soon as the session is ended.
Anyone have any idea how a procedure like this can be written or is there a better way I can bypass a trigger?

Thanks a lot!