Explanation:
The correct SQL command to grant read access to a table in Databricks (and standard SQL) is GRANT SELECT ON TABLE <table_name> TO <principal>.
Ultimate access to all questions.
A
GRANT USAGE ON TABLE orders TO 'user'
B
GRANT MODIFY ON TABLE orders TO 'user'
C
GRANT SELECT ON TABLE orders TO 'user'
D
GRANT READ ON TABLE orders TO 'user'
No comments yet.