I am using VS2022 17.14.5 with Oracle developer tools 23.8.1.0. I used Update Target to create a missing view in the target, but my target schema did not have the select grant on the underlying object in the view. The ‘Schema Compare Update Target Report’ did not mention any error. It stated that the view had been created. Also the Oracle Developer Tools Output reported the update was successful.
Sample end of report
The following objects are newly created.
RelationalView
MYSCHEMA.VWTestView
Sample ODT Output
Updating Target Connection....
MYSCHEMA updated successfully.
---------------------- Done ----------------------
The report and output should have mentioned the creation of the view failed with error ORA-01031: insufficient privileges error.
Please look into fixing this by reporting failed updates (object name and error message) in the report and ODT output window.