Post reply

SSIS security - roles

  • August 11, 2008 at 10:43 am

    #126920

    I have a user who is set up in the db_datareader and writer roles in a user database and in the db_dtsadmin role for the msdb database, but when he tried to update/import a package he gets the following error.

    "The EXECUTE permission was denied on the object 'sp_dts_listfolders', database 'msdb', schema 'dbo'."

    He is also set up in the Distributed COM Users group on this server.

    Is there a different security group he should be in? The TechNet acticle that shows the description of this role describes the db_dtsadmin roles as the sysadmin of SSIS packages so I'm a bit lost here.

    Thanks,

    Tim

  • January 15, 2009 at 8:25 am

    #927376

    I have them set up as dbo and they still get this error. What am I missing?

    ¤ §unshine ¤

  • January 15, 2009 at 9:52 am

    #927489

    Check the permission properties of db_dtsadmin and verify that it has execute permission for sp_dts_listfolders. It does in all my SQL instances and I think that's the default. Perhaps the permission was removed in your instance? Grant it if it's missing.

    Greg

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply