When a CAST Storage Service is installed or when a PostgreSQL instance is installed, two additional users/roles are created (operator/guest) by default as listed below. An additional user (postgres) is already present out of the box:
If you would like to change the passwords for these users, there are various methods. CAST recommends either using PgAdmin (which is bundled with CAST Storage Service) or use a SQL query. Both are explained below.
See Action items after changing the operator user password when using CAST Console for more information.
Right click the operator/guest user and choose Properties. Then click the Definition tab and enter the new password in the Password field. Click Save to action the changes.
Use the ALTER USER statement, where username is operator/guest and where password is the new password you would like to set:
ALTER USER username WITH PASSWORD 'password';