What are the effects of GRANT DELETE?

Question

What is the difference between:

GRANT DELETE ON TABLE1 TO ROLE1

and

GRANT DELETE TO ROLE1

One of our DBAs executed the second version by mistake. I want to be certain I understand all the ramifications.

Wont this remove any other permissions that were correctly assigned before executing that?

podiluska · Accepted Answer · 2012-09-25 14:36:17Z

up vote 3 down vote accepted

The first is table specific. The second allows deletion from any table

answered Sep 25 '12 at 14:36

podiluska
64826

That's what I thought :S – Andrei D Sep 25 '12 at 14:42

1 Answer