Repository and Cache Database Access and Privileges
The installer creates the repository and cache databases, it sets access and privileges for root, cisrepo and tutorial users.
The root user account is the DBA account for the entire PostgreSQL database.
The cisrepo user account is used to manage the TDV Server repository and cache databases.
The tutorial user account is used to manage the example Postgresql database used by the TDV Server for demo purposes.
Remote Access to the Repository
No user can access the repository nor the cache database remotely.
It is configured to only allow local connections.
Repository Settings
Repository settings are as shown in the following table.
Repository DB Name | Owner | Access privileges |
cisrepo | cisrepo | cisrepo=CTc/cisrepo |
inventory | tutorial | tutorial=CTc/tutorial |
orders | tutorial | tutorial=CTc/tutorial |
postgres | root | |
template0 | root | =c/root + root=CTc/root |
template1 | root | =c/root + root=CTc/root |
Cache Settings
Cache database settings are as shown in the table.
Cache DB Name | Owner | Access privileges |
ciscache | ciscache | ciscache=CTc/ciscache |
postgres | root | |
template0 | root | =c/root + root=CTc/root |
template1 | root | =c/root + root=CTc/root |
Data cached to relational databases is stored in clear text.
If flat file caching is used, the data is saved in binary format on the TDV installation drive and rendered in clear text. Secure access to HOMEDRIVE/temp or the customized location can be configured for file caching.