How do i find what user create an oracle object

Hi,
One can login to oracle as SYS and create a view in a different schema.
Eg:- create View ABC.MY_VIEW As select '1' COL1 From Dual

The MY_VIEW will then be listed with Owner as ABC. Is there a way to query that actually its the user -SYS who actually created this object?

Thanks
Sanj
IFSUKAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jiruizCommented:
Maybe I am wrong but I believe there are two ways to know who has create an object:

1. Logminer: But sure you don't have the archive logs for that
2. Enbled audit in the moment of creatio but I'm sure this is not the case


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Chakravarthi AyyalaDatabase AdministratorCommented:
Actions by SYS cannot be audited.  :(
jiruizCommented:
Yes, SYS can be audited:

http://justoracle.blogspot.com/2007/02/auditing-sys-users.html

or you can see Oracle Documentation: Oracle DAtabase Security Guide 10g Release 2 (B14266-04) The paragraph "Auditing Administrative Users" (page 12-3)
Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

IFSUKAuthor Commented:
Hi,
Thanks for all the questions, but it means the auditing has to be setup before the object is created.
Dont understand why oracle cant keep who created object by default. I mean it reatins the owner, but not the created by!

Thanks again
Sanj
IFSUKAuthor Commented:
I mean thanks for the answers! Strange EE own commnets cannot be edited!
Guy Hengel [angelIII / a3]Billing EngineerCommented:
This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.