+ Post New Thread
Results 1 to 10 of 10
MIS Systems Thread, Who accessed a users details? in Technical; Hi folks, I think I know the answer to this all ready but just to be sure: Is there any ...
  1. #1

    Join Date
    May 2010
    Location
    Stoke on Trent
    Posts
    77
    Thank Post
    8
    Thanked 3 Times in 3 Posts
    Rep Power
    9

    Who accessed a users details?

    Hi folks, I think I know the answer to this all ready but just to be sure:

    Is there any way at all to find out which teachers/staff have accessed a particular users details?

    From similar threads I've read, I'm guessing the answer is NO.

  2. #2

    Join Date
    May 2010
    Location
    Stoke on Trent
    Posts
    77
    Thank Post
    8
    Thanked 3 Times in 3 Posts
    Rep Power
    9
    digging in deep through this forum, someone mentioned 'SQL profiler' - anyone know if this is worth pursuing?

  3. #3
    Grey-gear's Avatar
    Join Date
    Nov 2009
    Location
    Derby
    Posts
    453
    Thank Post
    32
    Thanked 60 Times in 46 Posts
    Rep Power
    24
    If you have managing writes to make users you can see who has what policies, if I was doing it I would look at the users with System Manager 6. It may be different for yourself.
    Last edited by Grey-gear; 13th December 2013 at 09:39 AM. Reason: Because it did not make sense the first time

  4. #4

    Join Date
    May 2010
    Location
    Stoke on Trent
    Posts
    77
    Thank Post
    8
    Thanked 3 Times in 3 Posts
    Rep Power
    9
    Not quite sure what you are saying, perhaps I need to rephrase the question:

    If all teaching staff have read access to all student records
    Can I find out which teachers have accessed which records? (where no change has been made, they have just accessed the record)

  5. #5
    Grey-gear's Avatar
    Join Date
    Nov 2009
    Location
    Derby
    Posts
    453
    Thank Post
    32
    Thanked 60 Times in 46 Posts
    Rep Power
    24
    Oh? I think if you go to the sims server and have a look at the SQL I think that may show you what they been on but that could be if they have made changes only. Sorry I can't help more I never tried doing this myself.

  6. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    You'd be hard pushed to track read events. Tracking changes is hard enough

  7. #7

    Join Date
    May 2010
    Location
    Stoke on Trent
    Posts
    77
    Thank Post
    8
    Thanked 3 Times in 3 Posts
    Rep Power
    9
    Yeah... I think it's impossible, I just needed it confirming.

    It's not actually an issue as such, senior leadership are just looking at how secure our data is.

    I am a bit surprised that SIMs doesn't do this... I realise it'd generate a pretty HUGE log file that you'd probably never need to look at but I think parts of the NHS does this with their patient management systems... and it makes sense to do so. I don't think the Head will be pleased, especially given the cost of SIMs

  8. #8

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,958
    Thank Post
    109
    Thanked 482 Times in 331 Posts
    Blog Entries
    2
    Rep Power
    281
    It's not possible. Just logging into SIMS reads pupil data (through the home page widgets). Complete, all-user table scans are done frequently for many tasks, even if the pupil data is not displayed on screen (e.g. aggregate stats)

    So, in a nutshell, the answer is no.

    In places like the DVLA, a screen deals with a single, individual record - there are no pages of records like in SIMS. At the DVLA, every record access/view is logged. It's a different situation entirely.
    Last edited by jinnantonnixx; 13th December 2013 at 10:08 AM.

  9. Thanks to jinnantonnixx from:

    CapnPugwash (13th December 2013)

  10. #9

    Join Date
    May 2010
    Location
    Stoke on Trent
    Posts
    77
    Thank Post
    8
    Thanked 3 Times in 3 Posts
    Rep Power
    9
    Ah... That explains it. Now it does make sense, Cheers!

  11. #10

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,388
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Shame Capita can't give an option to use MS-SQL Audit, loads better then using profiler - can pick what tables to audit and less of a performance impact. OK don't think it works on Express but hey.

SHARE:
+ Post New Thread

Similar Threads

  1. AD export user details
    By wellscs in forum Windows Server 2000/2003
    Replies: 1
    Last Post: 12th August 2010, 09:08 AM
  2. Remove Access to "User Folder"
    By burgemaster in forum Windows Vista
    Replies: 1
    Last Post: 11th April 2009, 08:53 PM
  3. Remote access of user areas from home
    By everton4europe in forum Wireless Networks
    Replies: 5
    Last Post: 18th July 2008, 12:29 PM
  4. What is your school policy for pupils who access porn?
    By woody in forum School ICT Policies
    Replies: 24
    Last Post: 8th November 2005, 10:47 PM
  5. Access To User Profiles
    By Teacher_Tom in forum Windows
    Replies: 20
    Last Post: 2nd November 2005, 03:35 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •