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
Printable 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! :rolleyes:
simple, the owner did.Quote:
Originally Posted by khoar
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