Friday, March 9, 2012

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.sqlmonster.com2000: 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 SQLMonster.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.sqlmonster.com

No comments:

Post a Comment