User accounts


Viewing assistance

For a better view of the table, press F to view the page in full screen mode. To return to the normal view, press Esc.

The following table lists various user accounts that are created and used by TrueSight Server Automation - Data Warehouse.

User accounts
created or used/
Account Type

Purpose

Is the default password set?


Change in default password required?

Privileges

Account created by

Password
storage location

Encryption
mechanism

blauth

OS

Runs the authentication service

NA

NA

Owns the blauthserver files

Product installer

NA

NA

DWAdmin

Application


Administration task

NA

NA

Administrator user for the portal

Can log in to TrueSight Server Automation - Data Warehousefor administration; however, cannot see any data in the reports

Product installer

NA

NA

Any TrueSight Server Automation - Data Warehouse user

Application

User

No

NA

Can use the reporting functionality.

TrueSight Server Automation

NA

NA

TSSADW_DW

Database (SQL Server)

Owns the warehouse database schema

Yes

Change according
to your database policy

  • Is owner (dbo) of the reports database
  • Is the default database, TSSADW_DW_DB
  • Executes ETL jobs (using JDBC connectivity) by reading data from the TrueSight Server Automation database across the database link

Database creation script

NA

NA

TSSADW_ETL_MASTER

Database (SQL Server)

Owns the ETL master schema

Yes

Change according
to your database policy

  • Is owner (dbo) of the ETL master repository database
  • Is the default database, TSSADW_ETL_MASTER_DB
  • Uses JDBC connectivity for ETL job execution

Database creation script

NA

NA

TSSADW_ETL_WORK

Database (SQL Server)

Owns the ETL work schema

Yes

Change according
to your database policy

  • Is owner (dbo) of the ETL work repository database
  • Is the default database, TSSADW_ETL_WORK_DB
  • Uses JDBC connectivity for ETL job execution

Database creation script

NA

NA

TSSADW_DW

Database (Oracle)

Owns the warehouse database schema

Yes

Change according
to your database policy

  • Is owner of the reports database objects.
  • Executes ETL jobs (using JDBC connectivity) by reading data from the TrueSight Server Automation database across the database link.

Database creation script

NA

NA

TSSADW_ETL_MASTER

Database (Oracle)

Owns the ETL master schema

Yes

Change according
to your database policy

  • Is owner of the ETL master repository objects.
  • Uses JDBC connectivity for ETL job execution

Database creation script

NA

NA

TSSADW_ETL_WORK

Database (Oracle)

Owns the ETL work schema

Yes

Change according
to your database policy

  • Is owner of the ETL work repository objects
  • Uses JDBC connectivity for ETL job execution

Database creation script

NA

NA