ALTER USER lets you add a password to a user, including the system administrator.
ALTER USER <user> IDENTIFIED BY <password>.
where is the name of an existing user. This sets the user ’s password to be .
To change the sysadmin’s password, fore example, you would use the following code:
ALTER USER "sa" IDENTIFIED BY 'newPassword';
When connecting to s-Server through sqlline, you can specify a username with -n and a password by passing -p sqllineClient will ask for a password if you pass it –PASSWORD
For s-Studio, you can enter a user name and password in the Connection Properties dialog box. See - Entering a JDBC URL for s-Studio.
To use StreamLab or s-Dashboard after adding user passwords, you will need to set a default user name and password through WebAgent.
WebAgent has command line arguments for setting the default user/password. See Command Line Arguments for WebAgent in the Integrating with Other Systems Guide.