Grant the privilege to allow a user to pass a specific object privilege on to other users.
At least one of these conditions:
This statement grants the privilege to Mary to perform deletions on the table Sales:
GRANT DELETE ON Sales TO Mary
This statement grants the right to Joe to both perform deletions on the table Sales, and to grant the DELETE privilege to other users:
GRANT DELETE ON Sales TO Joe WITH GRANT OPTION