Error Log Shows Execute Permission Was Denied on the Object 'Fngetsitenumber'
Summary
Resolve the execute permission error being thrown.Symptoms
In the databaseCalls_Error.log file the following exception may be seen:The EXECUTE permission was denied on the object 'fn_GetAppState', database 'CM_CAS', schema 'dbo'.
The EXECUTE permission was denied on the object 'fnGetSiteNumber', database 'CM_CAS', schema 'dbo'.
Cause
This appears to be a database permissions issue on the SCCM database.Workaround
To workaround this issue, add the App Portal service account to the smschm_users role on the SCCM database. The smschm_users role grants Execute permission to the SCCM database.Additional Information
This issue is being tracked internally as Issue #IOA-000124115
No ratings
