Answer-first summary for fast verification
Answer: GRANT SELECT, USAGE ON TABLE customers TO john.smith@marketing.com
The correct statement to grant read access to the customers table is `GRANT SELECT, USAGE ON TABLE customers TO john.smith@marketing.com`. This command specifically grants the SELECT privilege, which is necessary for read access, and the USAGE privilege on the table to the specified user. This aligns with standard SQL and Azure Databricks documentation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
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
No comments yet.