PENDING CMPivot not showing results in the CMPivot window

[BobojoBaxter]

As title suggests, cmpivot runs, says it was successful, but nothing in the cmpivot pane. I checked SQL directly and I do see the results.
smsprov.log does show an error.

*~*~[42000][229][Microsoft][ODBC Driver 18 for SQL Server][SQL Server]The SELECT permission was denied on the object 'CMPivotResult', database 'CM_MEM', schema 'dbo'.     ThreadID : 18576 , DbError: 229 , Sev: 14~*~*
 
*** [HY010][0][Microsoft][ODBC Driver Manager] Function sequence error    SMS Provider    11/19/2025 8:20:06 PM    18576 (0x4890)

*~*~[HY010][0][Microsoft][ODBC Driver Manager] Function sequence error   [42000][229][Microsoft][ODBC Driver 18 for SQL Server][SQL Server]The SELECT permission was denied on the object 'CMPivotResult', database 'CM_MEM', schema 'dbo'.  ThreadID : 18576 , DbError: 0 , Sev: -1~*~*    SMS Provider    11/19/2025 8:20:06 PM    18576 (0x4890)

CMPivotQuery failed to run query.    SMS Provider    11/19/2025 8:20:06 PM    18576 (0x4890)

 

[Prajwal Desai]

Looks like a permission related to issue to me. See the below screenshot and confirm.

 

[BobojoBaxter]

Looks like a permission related to issue to me. See the below screenshot and confirm.

View attachment 7439

How do I set that? I've never had to before...