I restored a database but one of the users does not have access to a few stored procedures. I was told I can update this through the global synonyms, but am unsure of how to do so. For example:
User MGR can login but not user Test. When i check in synonyms sp_whateverproc1 ->sp_whateverproc200 under public belongs to SA. How can i make those procedures available to all users?