Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
John Smith, a new member of the Marketing team, needs read access to the customers table but currently has no data access. Which of the following statements correctly grants him the necessary access?
A
GRANT READ, USAGE TO john.smith@marketing.com ON TABLE customers
B
GRANT SELECT, USAGE ON TABLE customers TO john.smith@marketing.com
C
GRANT READ, USAGE ON TABLE customers TO john.smith@marketing.com
D
GRANT SELECT, USAGE TO john.smith@marketing.com ON TABLE customers
E
GRANT READ, USAGE ON customers TO john.smith@marketing.com
