RZ70: The EXECUTE permission was denied on the object ‘xx’, database ‘xx’, schema ‘sys’.

When you are executing transaction code RZ70, below ABAP dump generated,

Error 229 has occurred on the current database connection “DEFAULT”.
Database error text: The EXECUTE permission was denied on the object
‘xp_msver’, database ‘mssqlsystemresource’, schema ‘sys’.
Triggering SQL statement: “SELECT * FROM $PROC$master..xp_msver”

Solution

Launch and login to master database. Drill down from Master > Security > Roles > Database Roles > Public.

Right click on public and select Properties

Click on Securables page, look for schema “sys” and object name “xp_msver” (look for the specific object name, depending on which objects prompted). Under explicit, select Grant for Execute permission. Click OK to apply the change.

Reference

• 2812638 – SELECT permission was denied on the object ‘objects’, database ‘mssqlsystemresource’, schema ‘sys’.