Home » RDBMS Server » Server Administration » who created tables
who created tables [message #373651] Mon, 30 April 2001 07:19 Go to next message
Nick
Messages: 64
Registered: February 2000
Member
Hi,
I am able to find out the database-owner and created_time of created tables but i'd like to know who as 'OSUSER', on unix created these tables.

Thank you, Nick

Report message to a moderator

Re: who created tables [message #373660 is a reply to message #373651] Mon, 30 April 2001 14:08 Go to previous message
Jaco
Messages: 23
Registered: August 2000
Junior Member
Only I Know this answer
SELECT * FROM ALL_OBJECTS (You can find the owner,created date,time ...)
select osuser from v$session

Report message to a moderator

Previous Topic: how do you see all the tables in Oracle8 ?
Next Topic: create table ...
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 10:33:37 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.