-
How to determine last modifiet of view
Does anyone know if there is a way to detemine who was the last user to modify a view ?
A production view was change and I MUST find out who was responsible.
Thanks
-
The only information you will get is the timestamp IF you haven't modified it back.
It is unacceptable to allow non-DBA persons to modify schema's -- Shame on you!
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
Originally Posted by khoar
A production view was change and I MUST find out who was responsible.
simple, the owner did.
Jeff Hunter
-
Shame on me ?????
I'm just a consultant here. All production changes are "supposed" to go to Production Control, but it appears someone circumvented to rules. I'm just tryin gto find out who.
-
and you dont have any auditing turned on, shame on you indeed
anyway if you know when it was done, look at who logged into the server, or who logged in via the listener and where they came from
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|