Neoview User Management and Security Administration Guide (R2.5)

Table 5-19 VIEW NEO.HP_SECURITY.USERROLELOG
Example of ValueDescriptionTypeField Name
2009–05–16 10:17:15.034405Local date and time when
the action occurred
TIMESTAMPDATE_TIME
180Number of minutes offset
from Coordinated Universal
Time (UTC, equivalent to
GMT). A positive number
signifies that local time is
later than UTC; a negative
number signifies that local
time is earlier than UTC.
SMALLINTUTC_OFFSET
norastarrDatabase user or role to
which the action applies.
If the action identified in the
TYPE field is either “Role
created” or “Role deleted,”
this field contains a role
name; for all other actions,
the field contains a user
name.
CHAR(128)SUBJECT
ROLE.AUSRRole specified in the action,
or NULL if the subject of the
action was a role or the
action was to delete a user.
CHAR(128)PARTICIPANT
User createdDescription of the action,
one of:
User created
User deleted
Role created
Role deleted
Set default role
Grant role
Revoke role
Successful Login to
Database
Successful Login to Event
Viewer
Failed Login
Successful Login to
Neoview Platform
Password Change
CHAR(50)TYPE
SECURITYMGRDatabase user or role to
which the action applies.
If the action identified in the
TYPE field is either “Role
created” or “Role deleted,”
this field contains a role
name; for all other actions,
the field contains a user
name.
CHAR(128)ACTION_USER
Example Queries
This query reveals which user deleted the user user8:
SQL>select ACTION_USER from HP_SECURITY.USERROLELOG where SUBJECT = 'user8' and TYPE = 'User deleted';
This query displays the most recent user-management actions pertaining to the user “ONEILLC9”
by listing log entries in reverse order by timestamp:
User Management Views 125