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

Table 5-16 VIEW NEO.HP_SECURITY.USERINFO
Example of ValueDescriptionTypeColumn Name
MARVINMGRDatabase user nameCHAR(128)USER_NAME
2009–05–16 10:17:15.034405Local date and time when
the user was registered on
the Neoview platform
TIMESTAMPCREATION_TIME
180Number of minutes offset
between local time and
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 defined this user on
Neoview
CHAR(128)CREATING_USER
ROLE.DBADefault role of the userCHAR(128)DEFAULT_ROLE
2009–05–16 10:17:15.034405Local date and time when
the user last logged on
TIMESTAMPLAST_DB_LOGIN
180Number of minutes offset
between local time and
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 Queries
This query displays records representing all database users registered on Neoview:
SQL>select * from HP_SECURITY.USERINFO;
This query displays records for all users who currently have ROLE.MGR as their default role:
SQL>select * from HP_SECURITY.USERINFO where DEFAULT_ROLE = 'ROLE.MGR';
This query displays, for user's whose names start with “ONEILLC,” the creating user, default
role, and last login time:
SQL>select substring(user_name,1,15) as user_name, substring(creating_user,1,15) as creating_user,
substring(default_role,1,15) as default_role, last_db_login from hp_security.userinfo where user_name like
'ONEILLC%';
USER_NAME CREATING_USER DEFAULT_ROLE LAST_DB_LOGIN
--------------- --------------- --------------- --------------------------
ONEILLC10 SECURITYMGR ROLE.PUBS02 NULL
ONEILLC9 SECURITYMGR ROLE.PUBS01 2009-09-03 16:12:29.328665
--- 2 row(s) selected.
Roles for Database Users (HP_SECURITY.ROLEINFO)
The role information (ROLEINFO) view consists of one row per role defined on Neoview. At
any given time, this view reflects all roles defined on the Neoview platform. It excludes platform
user IDs such as SUPER.SERVICES.
If a role is deleted, the row for that role is deleted from this view, but changes pertaining to the
user will remain in the USERROLELOG view.
Neoview user names are unique across the platform.
User Management Views 121