有个需求,在 DB上 创建Federated Views, 输入了以下的命令,如果命令中db2inst1和 test的密码改了,要如何修改呢? 再重新用新的密码创建一遍?
CREATE SERVER test TYPE DB2/AIX VERSION '10.5.7' WRAPPER test AUTHORIZATION "db2inst1" PASSWORD "12345678" OPTIONS (DBNAME 'sample', NODE 'sample')
CREATE USER MAPPING FOR DB2INST2 SERVER test OPTIONS (REMOTE_AUTHID 'test', REMOTE_PASSWORD 'F)b|5L{#0M}8')
CREATE USER MAPPING FOR TOPRO SERVER test OPTIONS (REMOTE_AUTHID 'test', REMOTE_PASSWORD 'F)b|5L{#0M}8')