| LINKS |
|
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: ApexSQL Doc |
