When a user tries to bring in Transaction Details to Centage through CDI they receive the below error:
Exception: The EXECUTE permission was denied on the object 'DYN_FUNC_GL_Ledger_Name', database 'Your Database', schema dbo
The login being used to connect to the GP SQL Server does not have Execute permission on the database.
Steps to Resolve:
- Login to SSMS.
- Right Click on the Company Database.
- Click Permissions.
- Highlight the username and scroll through permissions to Execute.
- Check box for Grant.
Comments
Please sign in to leave a comment.