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

Products

• CA eHealth

Issue/Introduction

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

Environment

Release: LHBASC99000-6.2-eHealth-Live Health Upgrade Elements
Component: