Grant VIEW DEFINITION Permission Across Schemas - SQL Server
The following T-SQL statement will grant
view definition
permission on the
dbo
schema to everyone who has access to the database.
grant view definition on schema::dbo to public