I would like to be able to let our developers query the information_schema views (like information_schema.routines) in some of our production databases. Right now, it only let's them see objects that they have permissions to...
i.e. if they have been granted execute on a procedure, they can see it in the view, and they can;t see any other user created procedures, even those in the dbo schema.
This is interesting becauase they can do a sp_helptext on any procedure, but they can't retrieve a listing of the procedures from the information_schema.routines view.
I've googled this, but I can't find anything that tells me how to allow them to query the views. Any ideas?
More info: I created a SQL login and it is in the public server role. I added itas a user to a database, and put it in the public and db_datareader database role. Still can't see anything in information_schema.routines except for about 30 dt_ routines.