Problem
Credit Hound synchronisation fails during account opening. The following message is displayed:
On inspection of the Credit Hound.txt log file, the Exception reads as follows:
The EXECUTE permission was denied on the object 'xxxxxxx', database 'Credit Hound COMP000x', schema 'dbo'.
Applies to
Credit Hound v6
Solution
The SQL Database must be configured to allow each user the execute code permission for the dbo schema in the Credit Hound database.
Open SQL Server Management Studio
Expand the tree view to Databases>Credit Hound COMP000x>Security>Schemas
Double-click dbo to open its properties.
Select Permissions, then View database permissions
Select each of the users in turn, scroll down the list of Permissions and grant Execute to the user
Click OK, then OK and close SQL Server Management Studio
Related Product | Credit Hound |
Ref Number | KBA-03-03-009 |
Document Date | 7/7/2017 |
Original Author | Vince Hodgson |
Document Version | v1.1 |
Last updated | 20/03/2018 |
Update Author | Vince Hodgson |