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

Database Users and Their Roles (HP_SECURITY.USERROLEINFO)
The USERROLEINFO view consists of one row per combination of database user and role, so a
user who has multiple roles will be represented by the corresponding number of rows in the
view. At any given time, this view reflects all database users defined on the Neoview platform.
It excludes platform users.
Neoview user names are unique across the platform.
Column Definitions
Each row consists of the following columns:
Table 5-18 VIEW NEO.HP_SECURITY.USERROLEINFO
Example of ValueDescriptionTypeColumn Name
Dot JarvisDatabase user nameCHAR(128)USER_NAME
ROLE.DBARole nameCHAR(128)ROLE_NAME
YesWhether this is the user's
default role (Y or N)
CHAR(2)IS_DEFAULT
2009–05–16 10:17:15.034405Local date and time when
the user last successfully
logged on to the Neoview
platform
TIMESTAMPLAST_DB_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
2009–05–14 10:23:46.678768Local date and time when
the role was granted to
the user
TIMESTAMPGRANTED
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.
SMALLINTGRANTED_UTC_OFFSET
SECURITYMGRUser name of the user
who granted the role to
USER_NAME
CHAR(128)GRANTING_USER
Example Queries
If this query is executed by a user with ROLE.SECMGR or ROLE.MGR privileges, it displays
records representing all database users registered on Neoview:
select substring(user_name,1,20) as "User Name",
role_name,is_default from hp_security.userroleinfo;
User Name ROLE_NAME IS_DEFAULT
-------------------- ------------- ------------
ANNENYE ROLE.ROLE001 Y
User Management Views 123