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.