How to Obtain eHealth Web Users Through running a Sql query?

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

SUMMARY

Usually the eHealth web users can be found from ehealth OneClick. But those information can be also easily obtained through running a sql query.

INSTRUCTION

1. Start sqlplus

    In Windows:  sqlplus %NH_USER%/%NH_USER%@%NH_DB_CONNECT_STRING%

    In Solaris/Linux:  sqlplus $NH_USER/$NH_USER@$NH_DB_CONNECT_STRING

2. Enter the following query to list all ehealth web users

    select user_name from nh_user;

Here is an example of the output the query might display.

SQL> select USER_NAME from nh_user;

    USER_NAME

   --------------------

   admin

   ehealth

   test

   mike1

   jone1

The above output shows that there are five users who can run ehealth web reports.