msdb dtsltduser role

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » msdb dtsltduser role

msdb dtsltduser role

Rate Topic

Display Mode

Topic Options

Author

Message

pixye.sb

Posted Thursday, January 21, 2010 5:01 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, October 30, 2012 6:48 AM
Points: 62, Visits: 191

Hi, for a new applicatin that we have to install, it is needed for its sql login to have the dtsltduser role in msdb (dtsadmin or dtsoperator would work as well). Since the database will reside on a cluster with many other critical databases, of different suppliers, it is necessary to avoid security risks.
Is it dangerous to have a public user in msdb, in general, and in particular with dtsltduser role?
At the moment I have created the database with the required permissions on a test server, and I will keep it there until I am sure it is a safe configuration.
You opinion and experience will be appreciated.
Thanks in advance, sb

Post #851155

Greg Charles

Posted Thursday, January 21, 2010 11:05 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:28 AM
Points: 4,007, Visits: 4,854

As long as the user in msdb doesn't have any other permissions, I don't see any harm in it. The role only allows members to work with packages that are owned by the login and stored in msdb by executing stored procedures.

Greg

Post #851442

pixye.sb

Posted Friday, January 22, 2010 2:08 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, October 30, 2012 6:48 AM
Points: 62, Visits: 191

This is what I thought, but I wasn't sure.
Many thanks, sb

Post #851824

« Prev Topic | Next Topic »

Permissions