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>
Windows Live Hotmail now works up to 70% faster. http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_faster_112008
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?
Thanks.
Windows Live Hotmail now works up to 70% faster. http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_faster_112008
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 20 2008 - 10:35:12 CST