Solutions Products Download Purchase Support News Members Company
SITE FEED
Support Forum
The fastest and most effective to get answers to your questions quickly.
FAQs
Quick answers to common questions.
Troubleshooting
Known issues and basic troubleshooting techniques for problems or unexpected behaviors.
Knowledgebase
Technical tips, How-to articles, and other tutorials about ApexSQL Tools.
Online Documentation
All of our help files for download or convenient viewing online.
Videos
Watch product demos, training videos, or tutorials of our products' main features. 

ApexSQL Knowledgebase

Tips and How-to Articles for ApexSQL Tools


What are the required permissions to document jobs?

DESCRIPTION
The minimum permission requirement for jobs documenting are described in this article.

SOLUTION
Jobs are the part of SQL Server Agent and are accessed in different way comparing to regular database objects. Account which is used for jobs documenting should be granted the following permissions:
1. Login used to connect to SQL Server must be part of sysadmin server role. Here is the shot for that. In any other case no jobs will be documented:


2.Also the user related to this login must have db_creator role set on a database that is selected. Nothing specific needs to be set for msdb database.

AUTHOR
Dmitriy Dyubchenko

LAST REVIEW DATE
10 August 2009

Labels:



© 2010 ApexSQL Tools All Rights Reserved | 1.919.968.8444 | Contact Us | Terms of Use | Privacy Policy