The created database users are assigned to the database roles as follows:
-
The hsi user is assigned to the CONFIGGP database role (SQL Server only), the CLIENTGP database role (SQL Server and Oracle), and the SELECT_CATALOG_ROLE database role (Oracle only).
-
The hsicore user is assigned to the CLIENTGP database role.
-
The hsinet user is assigned to the CLIENTGP database role.
-
The viewer user is assigned to the VIEWGP database role.
-
The <WORKSTATION_ACCOUNT> user is assigned to the CLIENTGP database role. This user will not be created for new installations of OnBase, but may persist for systems upgraded from a version prior to 18.
-
The <Connection String User> is a custom, optional account created by the Database Administrator for use with Core application connectivity. Permissions and privileges required will be detailed below for each RDBMS platform. If this account is not created, the hsi account will be used in its place.