How to set or grant Bentley Map users in Oracle Spatial do not include delete?

Question

Hi Bentley Experts 
 We are setting up grants to our GIS users in database using Oracle spatial tables. The database admin grants the users including INSERT,SELECT and UPDATE. The activity is to have these 3 options only and not to include the DELETE option for the reason that, we don't want them to mistakenly delete some data in the map but during the post process, it turn out that the user can't able to post his work. The error message says that Delete grant is missing. Though this is true, the users activity is only to INSERT and UPDATE the data, there is no such a DELETE activity during the process. Why is this happened? Is this normal with BMap in Oracle Spatial Editing? If not, How we will go about it and have these 3 grants options only work without then able to delete? 
 Thank you 
 Jun

Jerry Walter - Bentley · Answer

Though I would not consider myself a expert ( :-)) . Part of the workflow for the feature is to allow the user to 'delete' the graphics in the drawing. If this is done then the user has effectively 'deleted' the record in the database. So you will have to prevent the user from deleting elements (after they have been locked of course) in the drawing to keep these two data storage entities in-synch. 
 
Even if you have a database trigger on the back end to prevent the deletion of the row, the graphics ion the drawing is already gone for the current edit session. If you are comfortable with that scenario ( having the graphics gone yet having the database record there during the current session), you could place a ondelete trigger on the table and not allow the delete to proceed in the database. The user could then re-query the deleted elements into the drawing.