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

SQL>select date_time, substring(subject,1,15) as subject, substring(participant,1,15) as participant,
substring(user_name,1,15) as username, substring(type,1,15) as type from hp_security.userrolelog where subject
= 'ONEILLC9' order by date_time desc;
DATE_TIME SUBJECT PARTICIPANT USERNAME TYPE
-------------------------- --------------- --------------- --------------- ---------------
2009-09-03 16:11:33.556952 ONEILLC9 ROLE.PUBS02 SECURITYMGR Grant Role
2009-09-03 16:11:06.175486 ONEILLC9 ROLE.PUBS01 SECURITYMGR User created
User Information for Platform Users (HP_SECURITY.SYSUSERINFO)
The platform user information (SYSUSERINFO) view consists of one row per platform user. At
any given time, this view reflects all platform users defined on the Neoview platform.
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 SYSUSERLOG view.
Neoview user names are unique across the platform.
Column Definitions
Each row consists of the following columns:
Table 5-20 VIEW NEO.HP_SECURITY.SYSUSERINFO
Example of ValueDescriptionTypeColumn Name
supermanPlatform user nameCHAR(128)USER_NAME
2009–05–16 10:17:15.034405Local date and time when
the user's account was
created on the Neoview
platform
TIMESTAMPCREATION_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.
SMALLINTCREATION_UTC_OFFSET
SECURITYMGRUser name of the person
who created the account
CHAR(128)CREATING_USER
SUPER.SUPERPlatform role assigned to
the user identified in
USER_NAME, one of:
SUPER.SUPER
SUPER.SERVICES
HP.SDI
HP.VTS
CHAR(17)USER_TYPE
2009–05–16 10:18:15.123456Local date and time when
the password was
modified
TIMESTAMPLAST_PWD_CHANGE
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.
SMALLINTPWD_UTC_OFFSET
126 User and Role Management