SQL Doc 2

Minimum database permissions required for the user running SQL Doc

When producing documentation for a database using SQL Doc, the user connecting to the database will need 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. See Permissions required to use SQL Compare.

In addition, the user will need 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.


Didn't find what you were looking for?