Post reply

Logins

  • December 17, 2008 at 11:54 pm

    #216721

    I have a task in where I need to know what user activity was done in past 1 week or later ...

    Or you can say A user logged in yesterday and deleted some data or did some insertion or soemthing etc etc how would I know is it stored in any table or is there any system functions which can tell me what a user activity was did yesterday......

    I hope you all understand my question....

    I know the above can be achieved by placing triggers on tables but i dont want to put a trigger .....

    thanks

  • December 18, 2008 at 1:22 am

    #914339

    SQL does not keep track of user actions. You can monitor this by setting up a trace with SQL Profiler and filter on the specified user. But be aware that this trace can get large proportions (depending on what you log and how heavy your db is used).

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • December 18, 2008 at 1:31 am

    #914343

    U can make DDL trigger to trackout DML changes from user.

    and make DDL trigger to trackout DDL Trigger for structure change.

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • December 18, 2008 at 8:53 am

    #914636

    My question is i need to track a user activity which was done in past (Yesterday) and i dont want put any trigger or so...

  • December 18, 2008 at 11:21 am

    #914786

    run the session and the other system view whose name i can't remember but it's not requests

    i have a join and dump the data into a table and check it once in a while

  • December 19, 2008 at 2:27 am

    #915053

    I don't think you'll be able to obtain the data you're looking for because SQL doesn't keep track of that out of the box. As others suggested, you'd need to set up a trigger to log that activity going forward, but its not possible to see who deleted or modified data yesterday.

  • December 19, 2008 at 9:23 am

    #915423

    Well its so strange that we cant keep a track who did what on yesterday as i said i am not suppose to have a trigger .....

    Thanks for all your help and answers

  • December 19, 2008 at 9:32 am

    #915435

    you can audit SQL, it's just not set up by default because not everyone needs it and everyone doesn't want to put up with the overhead and it requires a lot of customization

    all of our triggers go thorugh QA for performance testing first

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply