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

Column Definitions
Each row consists of the following columns:
Table 5-17 VIEW NEO.HP_SECURITY.ROLEINFO
Example of ValueDescriptionTypeColumn Name
ROLE.SCRMRole nameCHAR(128)ROLE_NAME
2009–05–16 10:17:15.034405Local date and time when
the role was defined on the
Neoview platform
TIMESTAMPCREATION
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
SECURITYMGRUser name of the person
who defined this role
CHAR(128)CREATING_USER
23Number of users who have
been granted this role
INTEGERUSER_GRANT_COUNT
4Number of users for whom
this is the default role
INTEGERDEFAULT_ROLE_COUNT
234Number of database
objects owned by this role
INTEGEROWNERSHIP_COUNT
Example Queries
This query displays records representing all roles defined on Neoview:
SQL>select * from HP_SECURITY.ROLEINFO;
This query displays records for roles that own no database objects:
SQL>select * from HP_SECURITY.ROLEINFO where OWNERSHIP_COUNT = 0;
This query displays records for roles with names starting “ROLE.PUBS”. (Substrings could be
used to make the output more readable.)
SQL>select * from hp_security.roleinfo where role_name like 'ROLE.PUBS%';
ROLE_NAME
CREATION UTC_
OFFSET CREATING_USER
USER_GRANT_COUNT DEF
AULT_ROLE_COUNT OWNERSHIP_COUNT
--------------------------------------------------------------------------------
------------------------------------------------ -------------------------- ----
------ -------------------------------------------------------------------------
------------------------------------------------------- -------------------- ---
----------------- --------------------
ROLE.PUBS01
2009-09-03 16:08:41.554209
-420 SECURITYMGR
1
1 0
ROLE.PUBS02
2009-09-03 16:08:45.741899
-420 SECURITYMGR
2
1 0
--- 2 row(s) selected.
122 User and Role Management