I want to give a fellow developer read-only access to a set of databases that collectively form an application. He wants to borrow some design ideas, and I am happy for him do this.
When I set him up with db_datareader access. he could only see the data. How do I also give him read-only access to the design of views, tables, functions and stored procedures?