If you can view sprocs but not execute sprocs due to your permissions, you can still roundabout run the sprocs for reading things.

Just copy the guts of the sprocs into their own standalone queries.