Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
John Smith, a new member of the Marketing team, currently has read access to sales tables but lacks the permission to delete rows. Which command would grant him the necessary delete access?
A
GRANT USAGE ON TABLE table_name TO john.smith@marketing.com
B
GRANT MODIFY ON TABLE table_name TO john.smith@marketing.com
C
GRANT DELETE ON TABLE table_name TO john.smith@marketing.com
D
GRANT MODIFY TO TABLE table_name ON john.smith@marketing.com
E
GRANT DELETE TO TABLE table_name ON john.smith@marketing.com
