0

I want to secure SQL Server Agent jobs with password or any other method is it possible?

Improve this question
1
  • 1
    AFAIK there is no such feature to safegurad job with password. You have to make sure proper rights given to account which are using the job so that they can run only what is required
    – Shanky
    Commented Feb 25, 2015 at 13:11

2 Answers 2

Reset to default
2

One alternative method which might help you out is to save your stored procedures and UDFs that the job may use (if any) WITH ENCRYPTION.

However, given the nature of your question, I wonder whether you really need to start a bottom-up review of your database systems security first, liaising with business owners regarding what permissions currently exist, and what the desired position should look like.

Improve this answer
0
1

You can do it using the Roles in the msdb and using the roles for the SQL Server Agent.

Detailed description can be found in the following article:

https://msdn.microsoft.com/en-us/library/ms190926.aspx

Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.