September 16, 2003 at 3:32 pm
Is there a way I can give my developers a way to create, edit and exec DTS pkg's w/out giving them admin rights?
Aurora
September 16, 2003 at 5:21 pm
Is this a development, or non-production, server? If so, then just give them dbo access to msdb that should cover things. I've played around giving more restrictive access but always found that there was some extra stored procedure, function or table that needed additional privelages assigned. Then it became too much like micro-management.
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
--------------------
Colt 45 - the original point and click interface
September 18, 2003 at 8:11 am
Thanks Phill, that just may work. This is definitely a development environment.
Aurora
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply