How to determine last modifiet of view
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How to determine last modifiet of view

  1. #1
    Join Date
    Jul 2006
    Location
    Midwest
    Posts
    4

    Question 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

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,478

    Cool


    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

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Quote Originally Posted by khoar
    A production view was change and I MUST find out who was responsible.
    simple, the owner did.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Jul 2006
    Location
    Midwest
    Posts
    4
    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.

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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
  •  



Click Here to Expand Forum to Full Width