can a group share (save over the same dts package) without being a server admin. For example, a group of people will support a set of DTS packages in DEV. They need the ability to save over the DTS package -- no matter who originally created from their group -- do not want to have to save another copy by another name, then rename, etc. Right now, our workaround is to use a SQL Server id and all associates in the same group know the ID and password -- so can resave the DTS packages as long as they are saved with this ID. (Owner of package still shows as Windows NT ID -- not SQL ID -- haven't figured that one) Would rather stick with NT authority and not have to remember to use a SQL ID and password. Cannot see how you can grant access to a DTS package. Would like to have a role with access, and members in this role can all access the same package (similar to RACF mainframe and parmlibs). Have searched but find no solution. Any help appreciated. Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DTS package sharing
- Thread starter pthomson2
- Start date
Go to Security -> Logins in Enterprise Manager. Right click logins and choose -> New Login. It'll give you the option of entering a Windows NT group (mapping a group to a SQL Login). Just click the box with the ... to the right of NAME to browse your user & user groups list. Leave Use Windows Authentication clicked. Then add to this login whatever permissions the SQL login has.
That's all there is to it. Now, I don't know of specific permissions for editing DTS packages and only that, but I'm assuming if you have the permissions set up already for a SQL Login, you can set the same ones up to their mapped Group login. Just make sure that all the users are part of the same Windows Group. Create a new one if you need to. And make sure they don't have SA or SysAdmin rights if they don't need them AND make sure they only have access to the appropriate databases.
If you want to revoke permissions, you'll have to play around with the various Fixed Server Roles and Fixed Database Roles (look these up in Books Online for more detail)
Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???
That's all there is to it. Now, I don't know of specific permissions for editing DTS packages and only that, but I'm assuming if you have the permissions set up already for a SQL Login, you can set the same ones up to their mapped Group login. Just make sure that all the users are part of the same Windows Group. Create a new one if you need to. And make sure they don't have SA or SysAdmin rights if they don't need them AND make sure they only have access to the appropriate databases.
If you want to revoke permissions, you'll have to play around with the various Fixed Server Roles and Fixed Database Roles (look these up in Books Online for more detail)
Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???
- Status
Similar threads
- Locked
- Question
- Locked
- Question