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

Table 5-20 VIEW NEO.HP_SECURITY.SYSUSERINFO (continued)
Example of ValueDescriptionTypeColumn Name
2009–05–16 10:17:15.082785Local date and time when
the user last logged on
successfully
TIMESTAMPLAST_LOGIN
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.
SMALLINTLOGIN_UTC_OFFSET
Example Query
This query lists all users who currently have HP.SDI privileges:
SQL>select * from HP_SECURITY.SYSUSERINFO where USER_TYPE = 'HP.SDI';
This query lists all ROLE.SECMGR users created by SECURITYMGR and when each was created:
SQL>select USER_NAME, CREATION_TIME from HP_SECURITY.SYSUSERINFO where USER_TYPE = 'ROLE.SECMGR' and CREATING_USER
= 'SECURITYMGR';
USER_NAME CREATION_TIME
-------------------------------- --------------------------
dbdev-user25 2009-08-14 15:26:36.528222
alias_oneillc_secmgr6 2009-09-03 15:51:02.149656
--- 2 row(s) selected.
User Configuration Change Log for Platform Users (HP_SECURITY.SYSUSERLOG)
The system user log view (SYSUSERLOG) consists of one row for each user-management action
pertaining to a platform user.
Column Definitions
Each row consists of the following columns:
Table 5-21 VIEW NEO.HP_SECURITY.SYSUSERLOG
Example of ValueDescriptionTypeField Name
2009–05–16 10:17:15.034405Local date and time when
the user-management 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
super–CA5572,
ROLE.SECMGR
User name of the user to
whom the change applies
CHAR(128)SUBJECT
User Management Views 127