Home Forums Article Discussions Article Discussions by Author Discuss content posted by shiva challa db_SProcReader role generator RE: db_SProcReader role generator
JeremyE
SSCoach
Points: 16121
More actions
October 8, 2008 at 4:20 pm
#882626
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