The execution of sp_sysmon or sp_monitor by an user with "sa_role" reports the following error:
Msg 10353, Level 14, State 6:
Server 'xxxxxx', Procedure 'sp_sysmon_collect', Line 202:
You must have any of the following role(s) to execute this command/procedure:'sa_role' . Please contact a user with the appropriate role for help.
(return status = -4)
SAP Adaptive Server Enterprise (ASE) 15.7 ESD#3 and later
sp_sysmon_collect , KBA , performance , stored procedure , role , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.