Page 1 of 1
Don't allow DELETE for a DB2 table.
Posted: Mon Jan 18, 2016 4:35 pm
by Pankaj Kumar
Is there a possibility to create a DB2 table in such a way that delete should be disabled for that table? But one can be able to insert a row. Is this possible?
Re: Don't allow DELETE for a DB2 table.
Posted: Mon Jan 18, 2016 4:44 pm
by William Collins
Talk to your DBA. Exactly what is needed depends on exactly your situation, but it can be done.
Re: Don't allow DELETE for a DB2 table.
Posted: Fri Jan 22, 2016 5:04 pm
by zprogrammer
You could check on this link for REVOKE but most shops only DBA has authority over this command
http://publibz.boulder.ibm.com/cgi-bin/ ... 0325102208