• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 378
  • Last Modified:

DB Delete Privileges

Is there a concept of DB2 having a table that has DELETE privileges

How does that work

How can I check to see if such a prvilege is active and how can I override it if necessary
0
Los Angeles1
Asked:
Los Angeles1
1 Solution
 
momi_sabagCommented:
in order to delete data from a table you need to be granted the explicit delete permission on that table unless you have an implicit delete permission

you would have an implicit permission if you created the table or you have some administrative authority such as dbadm, sysadm etc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now