Auditing attemped permission changes to a db, and index files.

From: Shawn (voxsj_at_hotmail.com)
Date: 06/12/03

  • Next message: Dorothy: "Application Roles and Encryption" 
    Date: 12 Jun 2003 08:50:15 -0700

    Hi,

    First let me apologize if this is a novice question, I have very
    limited experience with SQL Server. I work in System Engineering and
    have been tasked with finding a solution to the following issue fo a
    customer:

    I need to be able to monitor all attempted permission changes to a SQL
    db, this includes successes and failures. Plus I need to monitor the
    changes that are made to the index files, ect. I need to have the
    alerts placed in the event log, so that a custom rule in MOM will pick
    up on it. I already have an idea for the rule in MOM, I really just
    need to know where to look to turn on the auditing for db permission
    access.

    Thanks in advance for any help,

    Shawn

  • Next message: Dorothy: "Application Roles and Encryption"

    Relevant Pages

    • Re: Assessing needs to install one more SQL server for MOM
      ... From reading the SQL help files, I see that instances are generally not recommended for SQL-production environment (this is my case here, I will be using MOM in production environment). ... >I am trying to avoid installing more SQL servers than what I need. ... I have virtually dozens of> third-party applications that rely on that SQL server and I do not know if> by changing configuration to "Windows authentication only" to satisfy MOM> setup that could eventually break something down the road. ... > b) I have to enable IIS on such SQL server box. ...
      (microsoft.public.sqlserver.server)
    • Re: SMS database
      ... Both SMS 2003 and MOM 2005 require Microsoft SQL Server. ... SQL Server 2000 with Service Pack 3a or later is required for the SMS site ...
      (microsoft.public.sms.setup)
    • Re: Assessing needs to install one more SQL server for MOM
      ... I will buy a SQL server license now!!!. ... > I'd consider running MOM on another server that's less used. ... >> b) I have to enable IIS on such SQL server box. ...
      (microsoft.public.sqlserver.server)
    • Re: new to sql and need some help. connectivity problems.
      ... Did you install SQL Server or MSDE? ... Basically, on the client, you use SQL Server's "Client Network Utility" ... > i've installed sql on a dedicated box for the purpose of using it for mom and sms but the only problem is ... when i go to install sms or mom on the other boxes it doesnt see the sql server. ...
      (microsoft.public.sqlserver.server)
    • Quantcast