Grant Select to smsschm_users on all SQL Synonym
When CMCB or even CM12 creates an Inventory class, it also creates a SQL Synonym too. These SQL Synonyms, are basically the same as the SQL Views, with one key difference, they don’t have the permission set to allow for smsschm_users “select” access on them. This means that low rights users will receive an error when uses.
So what is this important? This is a great question, and the reason is that the behavior when importing sms_def.mof changes between CM07, CM12, and CMCB. The SQL Synonyms is named exactly what is created in older versions of CM. So When creating dashboard and report that will traverse all versions of CM. Only two SQL queries (RBA and non-RBA) are needed and therefore two different RDLs. Verse having three different SQL queries (RBA and two non-RBA depended on the version of CM) and therefore three different RDLs.