Hi, it's sql server 2008R2 environment. There are some stored procedures in a database under schema called schema1. I granted userA execute,select and view deifinition on that schema1 schema. But userA is still unable to see those stored procs which are under schema1. Am I missing anything here to do? Thanks.