You can assign SQL functions to both roles and users. If someone’s missing a function in one of your environments, we can help assign the correct permissions. Start by testing different functions across environments, example Mosprod, Mosrep, Mostest and identify what’s missing.
Once you’ve completed the testing, please raise a case, referencing the title of this article and including your test results, including the following information:
User’s name.
User’s role.
Environments that work as required.
Environments that aren't working as expected.
A list of functions that aren’t working.
Has anything been changed?
Is this related to one user or many?