When trying to add a new user or perform any other tasks on the foundation you get the below error:
The Execute permission was denied on the object 'sp_xml_preparedocument'.database'mssqlsystemresource'. schema 'sys'.
Foundation 11.x and 12.x
The error Execute permission was denied on the object 'sp_xml_preparedocument'.database'mssqlsystemresource'. schema 'sys'
is a SQL Database error and not related to Foundation.
The sp_xml_preparedocument is a Stored Procedure (SP) of SQL used for XML.
When reviewing the error message it seems that the permissions to execute this StoredPorcedure has been removed.
We suggest you get in touch with your Database Administrator and if further assistance is required to seek help from Microsoft support.