Stopping logins making schema changes

From: Dave (Anonymous_at_devdex.com)
Date: 06/10/04 

Date: Thu, 10 Jun 2004 02:38:21 -0700

We have a server that contains one 20Gb database and, unfortunately, the
application that connects to it has to have DBO rights or no rights at
all. (yeah great app!)

Howver, I've increasingly found that the developers have started making
schema changes without my knowledge and certainly no form of change
management involved.

Also, they've started adding DTS packages to the server.

Becuase it's a 24x7 I, as DBA, am increasingly concerned that they might
mess up the database and I get the 3am call to fix it.

Is there any way I can lock down the schema & DTS packages so that they
can't make changes or add things to the system.

Or even if there are any way to alert me if they make changes.

Thanks!

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: SQL Server 2005 DTS problem: "Error 21776: General Error"
    ... restoring on 2005 from the 2000 backup files has worked flawlessly for this ... stuck with the DTS packages. ... once we renamed the server we had problems. ... it's not related to the number of objects in the database). ...
    (comp.databases.ms-sqlserver)
  • Re: DTS packages on new SQL Server
    ... They are stored in the MSDB database, but moving that database is always ... You can load the DTS packages into Enterprise Mangler and save ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Best Practices
    ... That will create an excesive work load over your transactional server. ... The DTS packages are doing ETL into, specifically, ... tables in this DataWarehouse database. ... > Would it be better if in this DataWarehouse database I used views instead ...
    (microsoft.public.sqlserver.olap)
  • Re: Where are Active X scripts stored in SQL Server
    ... DTS packages are stored in the msdb database, ... database to a separate server and get the information from there. ... > My evaluation version of sql server recently expired. ...
    (microsoft.public.sqlserver.programming)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)