Reduction of SA

[robert030975]

I have a power user if you like who will be able to execute jobs, create SSIS packages etc. But can' t be an SA as it allows access to our payroll database. I only realised that they had SA when they where added on to the SQL server agent which allows the to execute jobsbut gives them SA.

Is there a way that it can be reduced?




Many Thanks


Robert

 

[mrdenny]

All users can be granted the rights create jobs. Add them to the SQLAgentUserRole role in the MSDB database.

This page shows how to allow users who are not admins to connect and upload packages to SSIS.

http://sqljunkies.com/WebLog/knight_reign/archive/2006/01/05/17769.aspx

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[robert030975]

Thanks I'll have a play around and post back.