Neoview User Management Information (R2.4 SP1)

3 User Status View
The User Status View (USERINFO) consists of one row per user. At any given time, this view
reflects all users defined on the Neoview platform, except the super ID and the services ID.
If a user is deleted, the user's row is deleted from this view, but changes pertaining to the user
will still exist in the User Log View.
Rows are in alphabetical order by USER_NAME. Neoview user names are unique across the
platform.
Timestamps reflect local time on the primary segment.
Column Definitions
Each row consists of the following columns:
Table 3-1 VIEW HP_USER_LOGGING.USERINFO
Example of ValueDescriptionTypeColumn Name
marvinmgrUser nameCHAR(32)USER_NAME
2009–05–16 10:17:15.034405Date and time when the
user was added on the
Neoview platform
TIMESTAMPCREATION
ROLE.DBACurrent role of the userCHAR(17)ROLE_NAME
2009–05–16 10:17:15.034405Date and time when the role
was last modified
TIMESTAMPROLE_MODIFIED
marvinmgrUser name of the person
who modified the role
CHAR(32)ROLE_MOD_USER
2009–05–16 10:17:15.034405Date and time when the
password was last modified
TIMESTAMPPWD_MODIFIED
marvinmgrUser name of the person
who modified the password
CHAR(32)PWD_MODIFIED_USER
Example Queries
List All Users and Their Roles
This query displays records representing all users registered on Neoview.
SQL>select * from HP_USER_LOGGING.USERINFO;
USER_NAME CREATION ROLE_NAME ROLE_MODIFIED
ROLE_MOD_USER PWD_MODIFIED PWD_MOD_USER
-------------------------------- -------------------------- ----------------- --------------------------
-------------------------------- -------------------------- --------------------------------
user1 2009-02-27 13:14:11.080552 ROLE.DBA 2009-02-27 13:14:11.080552 currmgr
2009-02-27 13:14:11.080552 currmgr
user2 2009-02-27 13:14:11.122739 ROLE.MGR 2009-02-27 13:14:11.122739 currmgr
2009-02-27 13:14:11.122739 currmgr
user3 2009-02-27 13:14:11.160474 ROLE.USER 2009-02-27 13:14:11.160474 currmgr
2009-02-27 13:14:11.160474 currmgr
user4 2009-02-27 13:14:11.194702 ROLE.USER 2009-02-27 13:14:11.194702 currmgr
2009-02-27 13:14:11.194702 currmgr
user5 2009-02-27 13:14:11.224447 ROLE.USER 2009-02-27 13:14:11.224447 currmgr
2009-02-27 13:14:11.224447 currmgr
user6 2009-02-27 13:14:11.554526 ROLE.DBA 2009-02-27 13:14:11.554526 currmgr
2009-02-27 13:14:11.554526 currmgr
user7 2009-02-27 13:14:11.789782 ROLE.USER 2009-02-27 13:14:12.229552 currmgr
2009-02-27 13:14:12.485495 currmgr
--- 7 row(s) selected.
Column Definitions 13