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

Table 5-22 VIEW NEO.HP_SECURITY.USERACCESSLOG
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, platform
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.CHAR(128)PARTICIPANT
User createdDescription of the action,
one of:
Successful Login to
Database
Successful Login to Event
Viewer
Failed Login
Successful Login to
Neoview Platform
CHAR(50)TYPE
SECURITYMGRDatabase user, platform
user, or role to which the
action applies, or NULL if
the action was failed login.
CHAR(128)ACTION_USER
Example Queries
• This query displays failed login attempts since October 20. If the person running the query
is logged on in the role ROLE.MGR, ROLE.SECMGR, SUPER.SERVICES or SUPER.SUPER
, the results include all failed login attempts. Other users can see information pertaining to
themselves.
select DATE_TIME,substring(subject,1,25) as "User Name", substring(participant,1,20) as "Role" from
neo.hp_security.USERACCESSLOG where DATE_TIME > timestamp '2009-10-20 00:00:00' and Type = 'Failed Login'
order by DATE_TIME ;
• This example query returns the ten most recent log entries.
SQL>select [first 10] date_time, subject, type from neo.hp_security.useraccesslog order by date_time desc;
DATE_TIME SUBJECT TYPE
---------------- ---------------------------- ------------------------------------------
2009-11-23 12:48:38.361777 qa012 Successful Login to Database
2009-11-23 12:48:13.633856 connect Failed Login
2009-11-23 12:47:56.845314 qa001 Failed Login
2009-11-23 12:47:20.705027 SUPERUSER Successful Login to Neoview Platform
2009-11-23 12:47:11.624121 SUPERUSER Failed Login
2009-11-23 12:43:42.094079 SUPERUSER Successful Login to Neoview Platform
2009-11-23 12:43:42.048442 SUPERUSER Successful Login to Neoview Platform
2009-11-23 12:43:41.793946 SUPERUSER Successful Login to Neoview Platform
2009-11-23 12:43:41.741122 SUPERUSER Successful Login to Neoview Platform
2009-11-23 12:43:41.701231 SUPERUSER Successful Login to Neoview Platform
User Management Views 129