November 29, 2007 at 12:46 pm
If I would like to user to do the following tasks.
1.will need Create, Read, Update, and Delete capabilities within the Database
2.responsible for any Extract, Transform and Load activities within the database
3.dbo rights within the database for ease of manipulating each other's SPROCS, VIEWS, FUNCTIONS, and TABLES.
4.ability to view and modify each other's Jobs and DTS Packages as well
5.rights to be able to execute system SPROCS
6.able to backup database
7.mail profile set up so that we can automate emails to ourselves (to monitor jobs or deliver data systemically)
November 30, 2007 at 2:05 am
Your answer is in step 3: dbo or better said db_owner rights is needed for this. Except the jobmanagement part which is a bit tricky since jobs are stored in the msdn database and unless you're a sysadmin, you can't edit jobs from other owners.
Markus
[font="Verdana"]Markus Bohse[/font]
November 30, 2007 at 6:23 am
Thank you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply