Which sequence (order) of object privileges should be used to grant a custom role read-only access on a table?
Which sequence (order) of object privileges should be used to grant a custom role read-only access on a table?
To grant a custom role read-only access on a table, the correct sequence of object privileges would involve granting usage on the schema and the database, and then granting the select privilege on the table. This ensures that the custom role can access the schema and the database, and has read-only access to the table itself. The correct option reflects this by providing schema usage, database usage, and table select privileges.
Answer- C
it's correct