Changing the Admin Password

Only Oracle user-managed services This topic applies only to Oracle user-managed services.

Oracle Stream Analytics comes with a default user, osaadmin. You must create your own password to login by using that user ID.

Use the following steps to change the password:

Change directory to top-level folder OSA-18.1.0.0.1 and execute the following command:

java -cp ./lib/jetty-util-9.4.7.v20170914.jar org.eclipse.jetty.util.security.Password osaadmin <your new password>
You can see the following codes in the console:
```
2018-03-01 15:37:55.800:INFO::main: Logging initialized @117ms to org.eclipse.jetty.util.log.StdErrLog
alphago
OBF:1u9d1uv81uha1u9r1ugg1uuy1ua5
MD5:34d0a556209df571d311b3f41c8200f3
CRYPT:osX/8jafUvLwA
```
Make a note of the obfuscated password string, marked in bold in the code in step 1, and copy it to a notepad.
Connect to the Oracle Stream Analytics metadata store database by using your SQL tool such as SQL Plus or SQL Developer.
The credentials must match the ones provided in the OSA-18.1.0.0.1/osa-base/etc/jetty-osa-datasource.xml file.
Update the osa_users table by using the command below and replace the obfuscated password with the string that you copied in step 2:
```
update osa_users set pwd='<CopiedObfuscatedPasswordString>' where username='osaadmin'
```

Note:

This on-premise version of Oracle Stream Analytics doesn’t support role based access. All users have admin privileges. To create additional users with obfuscated passwords, see Adding Users.