SSIS what rights for user to connect and view/run packages?

#31

Adding dts_operator role on system database msdb was needed to make it
work.
--

£Jim wrote:

Quote:

Thanks, lots of good info there. After I added the permissions from
the MS article the user can connect to SSIS, but cannot list/run the
saved procedures - execute permission is denied on sp_dts_listfolders
in database msdb.

#32

Adding dts_operator role on system database msdb was needed to make it
work.
--

£Jim wrote:

Quote:

Thanks, lots of good info there. After I added the permissions from
the MS article the user can connect to SSIS, but cannot list/run the
saved procedures - execute permission is denied on sp_dts_listfolders
in database msdb.

#33

Adding dts_operator role on system database msdb was needed to make it
work.
--

£Jim wrote:

Quote:

Thanks, lots of good info there. After I added the permissions from
the MS article the user can connect to SSIS, but cannot list/run the
saved procedures - execute permission is denied on sp_dts_listfolders
in database msdb.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SSIS what rights for user to connect and view/run packages?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: SSIS what rights for user to connect and view/run packages? - 03-26-2008 , 08:08 AM

Re: SSIS what rights for user to connect and view/run packages? - 03-26-2008 , 08:08 AM

Re: SSIS what rights for user to connect and view/run packages? - 03-26-2008 , 08:08 AM