0

I have a SQL Server 2005 database and I need to be able to grant a user(someday a group) read only database permissions with the ability to view but not run or modify stored procedures across over a dozen databases. Is there a way to do this with the current database roles included with SQL Server 2005 or does the user have to be granted permissions on each individual stored procedure. Thank you.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
user142253
  • 494
  • 1
  • 6
  • 16

1 Answers1

0

GRANT VIEW ANY DEFINITION TO [Domain\UserName] worked for me.

user142253
  • 494
  • 1
  • 6
  • 16