If we wish to change the password of an existing account, we can use the ALTER USER command:
ALTER USER 'data_analytics' WITH PASSWORD 'verystrongpassword';
We can also append a SUPERUSER or NOSUPERUSER option to the end of this query to grant or revoke superuser access.