| What user created this table ? [message #20018] |
Thu, 25 April 2002 00:23  |
Rob
Messages: 70
Registered: January 2000
|
Member |
|
|
Is there anywhere that stores the information of the USERID which created a table?
I was thinking along the lines of querying the system catalog ?
|
|
|
|
| Re: What user created this table ? [message #20020 is a reply to message #20018] |
Thu, 25 April 2002 00:56  |
Epe
Messages: 99
Registered: March 2002
|
Member |
|
|
Hello,
you can see the owner of a table, but as far as I know there is no storage of a creator. I think most of the time both will be the same though.
You can find the owner of a table in the "all_tables" or "dba_tables" views.
select owner
from all_tables
where table_name = '...';
Success,
epe
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
