Does SQL Doc require modifying/locking the database it documents?

jimhorn

Hi All

I have multiple copies of any given database: Dev, various flavors of Test, and Prod.
I have read-write privs on all databases except for prod, and readonly privs on prod.

Question: Does SQL Documentation require read-write access to the database that is being documented?

Thanks in advance.
Jim

Jessica R

Hi Jim,

Thanks for your post!

It does need read access, and if you are adding descriptions via SQL Doc, it will need write access as well.

Please see here for more information on the permissions needed: https://documentation.red-gate.com/display/SDOC3/Minimum+database+permissions+required+for+the+user+running+SQL+Doc