• You could also grant VIEW DEFINITION to the dbo schema or any other schemas in the database.

    USE [DATABASENAME]

    GO

    GRANT VIEW DEFINITION ON SCHEMA::[dbo] TO

    GO