Neoview User Management Information (R2.4 SP1)

4 User Log View
The User Log View (USERLOG) consists of one row for each user-management action.
Rows are in chronological order by EVENT_TIME and, when timestamps are not unique, in
alphabetical order by USER_NAME.
Timestamps reflect local time on the primary segment.
Column Definitions
Each row consists of the following columns:
Table 4-1 VIEW HP_USER_LOGGING.USERLOG
Example of ValueDescriptionTypeField Name
2009–05–16 10:17:15.034405Date and time when the
user-management action
occurred
TIMESTAMPEVENT_TIME
norastarrUser name of the user to
whom the change applies
CHAR(28)USER_NAME
User createdDescription of the
user-management action,
one of
User created
User deleted
Grant role
Revoke role
Password changed
CHAR(50)USER_ACTION
ROLE.DBARole of the user before the
user-management action
CHAR(17)PREV_ROLE_NAME
ROLE.DBARole of the user after the
user-management action
CHAR(17)NEW_ROLE_NAME
marvinmgrUser name of the person
who made the change
CHAR(32)MODIFYING_USER
Example Queries
List the 5 Most Recent User Management Actions
This query lists the five most recent user-management actions.
SQL>select [first 5] * from HP_USER_LOGGING.USERLOG Order by EVENT_TIME
Desc;
EVENT_TIME USER_NAME USER_ACTION
PREV_ROLE_NAME NEW_ROLE_NAME MODIFYING_USER
-------------------------- -------------------------------- --------------------------------------------------
----------------- ----------------- --------------------------------
2009-02-27 13:14:12.801213 user8 User deleted
currmgr
2009-02-27 13:14:12.665304 user8 User created
ROLE.DBA currmgr
2009-02-27 13:14:12.485495 user7 Password changed
currmgr
2009-02-27 13:14:12.229552 user7 Grant Role
ROLE.USER currmgr
2009-02-27 13:14:12.009643 user7 Revoke Role
ROLE.DBA currmgr
--- 5 row(s) selected.
Column Definitions 15