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 update them. Which command would you use to grant him update 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 UPDATE TO TABLE table_name ON john.smith@marketing.com
D
GRANT UPDATE ON TABLE table_name TO john.smith@marketing.com
E
GRANT MODIFY TO TABLE table_name ON john.smith@marketing.com
