Question 300
An investigator suspects secondary roles influence a SELECT's authorization. Which session control should they review?
Explanation
Correct Answer
Correct: USE SECONDARY ROLES setting. USE SECONDARY ROLES specifies whether eligible secondary roles contribute to access.
Incorrect Answers
Incorrect for this requirement: CURRENT_ROLE() returns the session's current primary role; the problem instead calls for USE SECONDARY ROLES setting.
Incorrect for this requirement: GRANT ROLE assigns role membership to a user or another role; the problem instead calls for USE SECONDARY ROLES setting.
Incorrect for this requirement: USE ROLE switches the session's primary role; the problem instead calls for USE SECONDARY ROLES setting.