who created the table?

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Thu, 20 Nov 2008 10:35:12 -0600
Message-ID: <BLU108-W25C690AB64BAF6A0B090EF970C0@phx.gbl>

How do I determine which user actually created a table?  

I have a table named ???? under schema A. I have numerous schemas/users that have CREATE ANY TABLE system privilege. I have the OBJECT_ID of the table.  

How do I join USER$, TAB$, and so on to find the actual user that created the table?  


Windows Live Hotmail now works up to 70% faster. http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_faster_112008
Received on Thu Nov 20 2008 - 10:35:12 CST

Original text of this message