How to set passwords (e.g. for the system user) to null, making a password not needed to get into the system.

This example resets password to Null for system and for user account mjane 

First, login to the meta schema (pre-2.5 platforms) in the database and run the following SQL command:

update TRIRIGA.USER_CREDENTIALS set TRIRIGA.USER_CREDENTIALS.PASSWORD = NULL where USER_ACCOUNT = 'system';

Note that if you are doing this on a post-2.5.x platform installation you'll need to replace the "TRIRIGA" schema with the "TRIDATA" schema. For example:

update TRIDATA.USER_CREDENTIALS set TRIDATA.USER_CREDENTIALS.PASSWORD = NULL where USER_ACCOUNT = 'system';

or for account mjane

update USER_CREDENTIALS set USER_CREDENTIALS.PASSWORD = NULL where USER_ACCOUNT = 'mjane';