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.
-
To Undo: REVOKE DELETE TO ROLE1– Gordon BellCommented Sep 25, 2012 at 14:38
-
Wont this remove any other permissions that were correctly assigned before executing that?– Andrei DvoynosCommented Sep 25, 2012 at 14:41
Add a comment
|
1 Answer
The first is table specific. The second allows deletion from any table
