Results 1 to 7 of 7

Thread: Someone changing permissions..

  1. 03-01-2005, 12:46 PM #1
    DBFan
    DBFan is offline Registered User
    Join Date
    Aug 2004
    Location
    USA
    Posts
    80

    Someone changing permissions..

    Someone is changing permissions on our production sql databases frequently which is causing big problems..any idea how to know who is changing and when? Any code that can be written to capture such activity?

    thanks,
    dbfan.
    Reply With Quote Reply With Quote
  2. 03-01-2005, 01:17 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Run SQL profiler.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 03-01-2005, 01:41 PM #3
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    If running profiler is not possible then you can create a server side trace for event id 103, event_name "Audit Object GDR" using sp_trace_setevent and log the output to a file for later analysis.
    Reply With Quote Reply With Quote
  4. 03-01-2005, 07:34 PM #4
    DBFan
    DBFan is offline Registered User
    Join Date
    Aug 2004
    Location
    USA
    Posts
    80
    thanks for the suggestions..
    Reply With Quote Reply With Quote
  5. 03-02-2005, 04:13 AM #5
    Rawhide's Avatar
    Rawhide
    Rawhide is offline Registered User
    Join Date
    Feb 2003
    Posts
    1,048
    You can also try denying everyone the ability to do that and see who yels first.
    Reply With Quote Reply With Quote
  6. 03-03-2005, 03:19 PM #6
    DBFan
    DBFan is offline Registered User
    Join Date
    Aug 2004
    Location
    USA
    Posts
    80
    Is there any tool that we can buy to log or audit user and permission changes?
    Reply With Quote Reply With Quote
  7. 03-04-2005, 10:26 AM #7
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Yes, take look at Lumigent's Entegra.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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