This post explains how to change the login username for P6 Professional Standalone supported with SQLite. P6 Professional standalone is a single user application, the user name is “admin” by default, but you can also customize the user name when creating the P6 database and configuring the connection in SQLite.
1. Firstly please double check there is only one user created for P6 standalone by executing below query against the P6 database.
SELECT * FROM USERS ;
2. If only one record is returned, then you can change the user login name by executing below SQL statement against the P6 database. Replace {your user name} accordingly.
UPDATE USERS SET USER_NAME = '{your user name}' ;
3. Now you can log on P6 with this new user name {your user name}.
4. If you only want to change the visual representation of the user’s name in P6.
UPDATE USERS SET ACTUAL_NAME = '{your actual name}';