We’ve been looking into using Least Privilege with our Development environments so tweaking some dev teams access.

On a DB server one of the requests to come in is create Agent Jobs.

Microsoft has set up 3 fixed roles for us to use. Each adds more permissions and all the subsequent roles access.

http://msdn.microsoft.com/en-us/library/ms188283.aspx

sqlserver_logo

Advertisements