Background information - one test environment, one production environment. Test & Prod both have the same data model, users and roles.
A change was made to an existing stored procedure, applied to test environment for testing, all worked then promoted to production. In production, users are not able to see the changes and it still works in production as though no changes have been applied to stored procedure.
The DBA has checked, the procedure in production does contain the changes, it is the same as the one in test. It has the correct private synonym, execute rights on the procedure for the relevant role. Users are assigned to the relevant roles in prod as they are in test.
Does anyone know what could be the cause or what else I could be checking for?