Error SQL72018: Permission could not be imported but one or more of these objects exist in your source. Errors occurred while modeling the target database. Deployment can not continue.
I got this error in my jenkins job what is the reason and how to solve give some inputs?
Mohamed Azarudeen ZPosted May 9, 2023, 12:14 PM
This could be due to a variety of reasons, such as missing dependencies, conflicts with existing objects, or invalid permissions.
To solve this error, you can try the following steps:
Check the detailed error message and identify which object(s) is causing the issue.
Verify that all dependencies required for the object(s) to be deployed are included in the project.
Check if the object(s) already exist in the target database, and if so, verify that the permissions are correct and match the source.
Ensure that the user deploying the project has the required permissions to create or modify objects in the target database.
Try changing the deployment options to "Ignore permissions" to bypass the permission errors during deployment.
If the issue persists, you may need to manually modify the target database to fix the permissions issue.