Minimum database permissions required for the user running SQL Doc
Published 03 May 2019
When producing documentation for a database using SQL Doc, the user connecting to the database needs to be granted permissions to the database and its objects.
SQL Doc uses the SQL Compare engine, so the permissions required are the same as SQL Compare. For more information, see Permissions required to use SQL Compare.
The user also needs to have modify permissions to the database to be able to add the descriptions; specifically, EXEC rights to the system stored procedures sp_addextendedproperty, fn_listextendedproperties, and sp_dropextendedproperty. The user needs CONTROL or ALTER permissions as well on the objects that descriptions will be added to. The user also needs VIEW SERVER STATE permissions.