ALTER USER

Version 5.2 Feature

ALTER USER lets you add a password to a user, including the system administrator.

Syntax

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';

Using Passwords When Connecting to s-Server

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.