In the previous recipe, we saw how we can use trusted connections in Java. In this recipe, we will use trusted connections in PHP. Starting from DB2 9.5 FP3, the ibm_db2
extension for PHP supports trusted connections. We will use this extension to see how we can create trusted connections and how we can switch user IDs on an established trusted connection.
CREATE TRUSTED CONTEXT ctx_common
BASED UPON CONNECTION USING SYSTEM AUTHID db2admin
ATTRIBUTES (ADDRESS 'localhost',
ENCRYPTION 'NONE')
ENABLE
WITH USE FOR tcuserwoa WITHOUT AUTHENTICATION,
tcusera WITH AUTHENTICATION;
This trusted context will allow tcuserwoa
to use a trusted context without authentication and tcuserwa
to use a trusted context with authentication.