VIEW DEFINITION permission was denied
I am trying to create my first set of SQL Docs and I am having trouble with "VIEW DEFINITION permission was denied". I have two datasets that I work with, one is in it's own database where I have full permission and here SQL DOCs works fine. The other is on a specific Schema in a database where I only have permission over that schema and not the whole database. I have two specific questions:
1. Is there anyway of creating an SQL DOCs limited to schema level (for example by disabling the documentation of server info etc)?
2. If not what is the minimum level of permission I need at database level? They are very resitrictive about granting too much permission here at my Company.
I would greatly appreciate any help I can get on this. I've spent loads of time creating extened properties within the tables of my schema and it would be a shame to waste them