Answer-first summary for fast verification
Answer: 1. Database: Usage, 2. Schema: Usage, 3. Table: Select
The correct answer is C because granting read-only access to a table requires both USAGE and SELECT privileges in the proper sequence. USAGE privilege must be granted first on the database and schema to allow the role to see these objects, then SELECT privilege on the table to enable data access. This sequence is essential because a role cannot access a table if it cannot first see the database and schema containing it. The community discussion confirms this with 100% consensus on answer C, with MultiCloudIronMan's detailed explanation highlighting that USAGE alone doesn't provide data access and must be combined with SELECT in the correct order.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which order of object privileges should be used to grant a custom role read-only access to a table?
A
B
C
D
