Don't allow DELETE for a DB2 table.

RDBMS from IBM and IBM's Hierarchical DBMS and Transaction Manager (IMS DC).
Forum rules
Post Reply
Pankaj Kumar
New Member
Posts: 2
Joined: Wed Aug 06, 2014 11:23 am

Don't allow DELETE for a DB2 table.

Post 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?
Top
William Collins
Global Moderator
Global Moderator
Posts: 490
Joined: Sun Aug 25, 2013 7:24 pm

Re: Don't allow DELETE for a DB2 table.

Post by William Collins »

Talk to your DBA. Exactly what is needed depends on exactly your situation, but it can be done.
Top
zprogrammer
Global Moderator
Global Moderator
Posts: 588
Joined: Wed Nov 20, 2013 11:53 am
Location: Mars

Re: Don't allow DELETE for a DB2 table.

Post 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
zprogrammer
Top
Post Reply

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

Register

Sign in

Return to “IBM DB2 and IMS DB/DC”