What is the best method to control developer access [SQL2000] via enterprise manager without granting administrator access. I have a heavily shared server and want to restrict the level of access granted. The developers need:
1). access to view, update and execute DTS packages
2). view and start SQLAgent jobs.
They cannot have either sa or System Administrator role.