Page 1 of 1

create a table in such a way that Delete cannot be used?

Posted: Wed Sep 17, 2014 2:21 pm
by ramu9935
How to create a table in db2 in such a way. delete should be disabled i.e no one should be able to delete any row or column . But can be able to insert a new row.

Please suggest how to do the above.Thanks alot !

Posted: Mon Oct 13, 2014 3:51 pm
by dhiraj
Don't provide GRANT option for DELETE to any one...