Prevent DTS permission?

From: Bryan Fritchie (
Date: 02/16/04

Date: Mon, 16 Feb 2004 14:20:33 -0600

Is there a way to grant a SQL Server user permission to work on the database
(create/edit/delete tables/stored procs), but prevent them from performing a
DTS copy of the database to a different machine? We have clients who need
to have full control of their database, except we want to prevent them from
making backups of the live data. They can't perform a backup because they
do not have permission to the file system, but DTS copies are still