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
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:
- cd $NH_HOME/oracle/sql
- Save a backup copy of nhv_stats_data_views.sql
- Upload the new version of nhv_stats_data_views.sql and save it in $NH_HOME/oracle/sql
- $NH_HOME/bin/sys/nhisql "@nhv_stats_data_views.sql"
- 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.