Permissions

If a person needs to see, modify, create, and execute stored procedures and
DTS Packages on SQL server, what would be the minimum set of permissions
using server roles or database roles to allow this to happen?
Message posted via http://www.droptable.com
2000: sysadmin.
2005: sysadmin or GRANT ALTER TRACE TO ...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Robert R via droptable.com" <u3288@.uwe> wrote in message news:570fb034e80e6@.uwe...
> If a person needs to see, modify, create, and execute stored procedures and
> DTS Packages on SQL server, what would be the minimum set of permissions
> using server roles or database roles to allow this to happen?
>
> --
> Message posted via http://www.droptable.com