IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows — Question 43

Which of the following is TRUE regarding user switching in a trusted context?

Answer options

• A. You cannot switch user id in a trusted context
• B. You can issue a switch-user request within a transaction
• C. The new user must have the connect-privilege on the database for it to succeed
• D. No password is ever required for the new user as an authentication is established in the trusted connection

Correct answer: D

Explanation

Option D is correct because when operating in a trusted context, the authentication is handled by the trust relationship, eliminating the need for a password. Option A is incorrect as user ID switching is possible in a trusted context. Option B is also incorrect because issuing a switch-user request during a transaction may not be permitted. Option C is wrong because while having connect privilege is beneficial, it is not a requirement for the switch to succeed in a trusted context.