asdsfssd (6/11/2013)
SQL2000What are the minimum privileges / permissions / database roles needed to grant a user (besides granting sysadmin) to:
1) Create and run DTS packages.
2) Create, run and review job history.
For #1: I am guessing DB_DATAREADER and DB_DATAWRITER to MSDB??
For #2: I'm not sure about granting MASTER db.
What is the minimum I should grant?
Thanks.
I'm pretty sure that, in SQL Server 2000, only SA privs will fit the bill here.
--Jeff Moden
Change is inevitable... Change for the better is not.