Configuring the Spotfire database account to the Windows domain account

If you are using an Oracle database, this is the third step in setting up Kerberos to log in to the Spotfire database.

Procedure

Log in to the Oracle database instance with SYSDBA privileges to manage accounts.
Connecting to a database with connection identifier ORCL as sysdba
```
sqlplus sys@ORCL as sysdba
```
Alter the Spotfire database account so that it is identified externally by running the following command:
```
SQL> alter user <SPOTFIREDB_USERNAME> identified externally as '<SPOTFIREDB_USERNAME>@
REALM>';
```
Replace <SPOTFIREDB_USERNAME> and <REALM> with the Spotfire database account name and the Kerberos realm. Make sure to use uppercase letters when specifying the Kerberos realm.
```
SQL> alter user spotuser identified externally as
'spotuser@RESEARCH.EXAMPLE.COM';
```
Test the Kerberos-enabled Spotfire database account by opening a command prompt running as the created Windows domain account. It should now be possible to connect to the database using the following command, assuming the connection identifier is ORCL: > sqlplus /@ORCL

Note: It is assumed that Kerberos authentication is already set up for the Oracle client.