Question 320
A service user needs least-privilege READ_ONLY selected automatically at session start. What default property addresses this?
Explanation
Correct Answer
Correct: session primary role. DEFAULT_ROLE sets a user's default primary role on login when applicable.
Incorrect Answers
Incorrect: DEFAULT_WAREHOUSE sets a user's preferred initial compute warehouse; this case calls for session primary role.
Incorrect: DEFAULT_NAMESPACE selects the initial database and schema context; this case calls for session primary role.
Incorrect: DISABLED user property blocks the specified user from logging in when the account is disabled; this case calls for session primary role.