sql server roles

Question

sql server roles

HBK_4700

SSCrazy Eights

Points: 8932
More actions
June 27, 2012 at 8:09 pm

#276977

Which role i need to select for a login to give jobs admin access. thanks
basically login needs to create\execute sql jobs/SSIS
bulkadmin
dbcreator
diskadmin
processadmin
securityadmin
serveradmin
setupadmin
sysadmin

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

SQL Show SSCertifiable Points: 6143 More actions · Answer 1

to access sql agent jobs, a login needs to be assigned SQLAgentUserRole, SQLAgentReaderRole and SQLAgentOperatorRole (Operator is the most privileged one)

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

to run SSIS packages, you may need a Proxy Account.

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/69441/

Sysadmin will be too much for these kind of activities.

Arul R SSCommitted Points: 1595 More actions · Answer 2

Hi ..

Please refer the below link.

It may be help you.

http://www.codeproject.com/Articles/66827/Few-Step-s-to-Remove-SQL-Server-Database-User-s

http://www.codeproject.com/Articles/37274/Working-with-SQL-Server-Logins

kyle1zoe Newbie Points: 9 More actions · Answer 3

ghjhjhg

sms integration[/url], text message software[/url] and A sms business[/url] will help to develop a technique for a company’s mobile platform by helping to design a true mobile website (as opposed to a traditional site viewed on a laptop or desktop) and designing an extensive SMS plan.