Don't allow DELETE for a DB2 table.
-
- New Member
- Posts: 2
- Joined: Wed Aug 06, 2014 11:23 am
Don't allow DELETE for a DB2 table.
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?
-
- Global Moderator
- Posts: 490
- Joined: Sun Aug 25, 2013 7:24 pm
Re: Don't allow DELETE for a DB2 table.
Talk to your DBA. Exactly what is needed depends on exactly your situation, but it can be done.
-
- Global Moderator
- Posts: 588
- Joined: Wed Nov 20, 2013 11:53 am
- Location: Mars
Re: Don't allow DELETE for a DB2 table.
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
http://publibz.boulder.ibm.com/cgi-bin/ ... 0325102208
zprogrammer
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute