DTS Security

From: Adrian (adrianw@persoft.com.my)
Date: 08/16/02 

From: "Adrian" <adrianw@persoft.com.my>
Date: Thu, 15 Aug 2002 20:29:53 -0700

Hi,
  I want to create a user id where this id can only run
DTS. Other function like starting of the SQL Agent, backup
database should not be given access right. Could anyone
help what type rights should i assign to this userid.

Thanks
  Adrian

Relevant Pages

  • RE: Performance problem
    ... I started the SQL Agent jobs, ... BACKUP DATABASE successfully processed 249 pages in 0.327 seconds ... When we stop the BizTalk process the activity on the sqlserv.exe process ...
    (microsoft.public.biztalk.general)
  • Re: backing up sql server DB nightly
    ... There are 2 options to schedule a backup of database. ... Maintenance plans use SQL agent to schedule so ensure that SQL Agent service ...
    (microsoft.public.sqlserver.programming)
  • Re: Database Transfer Problem
    ... Most definitely you can take a backup with users in the DB. ... SQL Server will back up the log after the data file to capture changes made whilst the backup was taking place ... Can I run backup while> users are accessing the database? ... I may as> well kick all users out and run the DTS package. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Database Transfer Problem
    ... Can you tell me a bit more about the Backup option? ... database changes which are taking place while the backup is running? ... well kick all users out and run the DTS package. ... >> such isolation, so that the task runs agains a 'static snapshot' of the ...
    (microsoft.public.sqlserver.dts)
  • Re: Copying functions
    ... do a backup on the one database and restore the backup to ... your database using DTS instead of a backup and restore? ... I guess it has to do with what order DTS drops and creates everything. ...
    (microsoft.public.sqlserver.dts)
Loading