How to create a read-only eHealth user for dbApi view access using a one-off (169829)

Document ID : KB000020972
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

The read-only user created by the nhManageUser command cannot access some dbApi views. There is a one-off available to fix this. The one-off will be added into eHealth 6.3.1.03

Solution:

The one-off (169829) consists of as SQL file named v_stats_data_views.sql.

Please follow the steps below to apply the one-off:

  1. cd $NH_HOME/oracle/sql
  2. Save a backup copy of nhv_stats_data_views.sql
  3. Upload the new version of nhv_stats_data_views.sql and save it in $NH_HOME/oracle/sql
  4. $NH_HOME/bin/sys/nhisql "@nhv_stats_data_views.sql"
  5. When querying any dbAPI views as a user other than $NH_USER, including nhv_stats_data_views, the view name must be fully qualified as UserName.ViewName, where UserName is the value of $NH_USER.

For example:

admin.nhv_stats_data_views
admin.NHV_ST_B_ATMWANIF