Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 dts/jobs run by a "group" without sa privelages

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-07-15 : 07:46:05
Mario writes "Okay, here is the problem we are trying to get around. We create several dts packages and jobs that call dts packages when executing. I am trying to find a way for a user within a certain user group that does not have sa privelages to be able to run the job/dts package. Since the dts packate or job was created by a user with sa rights, the group cannot execute the package or job. Is there a way around this without giving the user group sa rights?"
   

- Advertisement -