Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

msdb dtsltduser role Expand / Collapse
Author
Message
Posted Thursday, January 21, 2010 5:01 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, September 11, 2013 1:41 AM
Points: 62, Visits: 195
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
Posted Thursday, January 21, 2010 11:05 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:17 AM
Points: 4,065, Visits: 5,315
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
Posted Friday, January 22, 2010 2:08 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, September 11, 2013 1:41 AM
Points: 62, Visits: 195
This is what I thought, but I wasn't sure.
Many thanks, sb
Post #851824
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse