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

ORVILLETANG5 ROLE.SECMGR Yes
ORVILLETANG6 ROLE.SECMGR Yes
ORVILLETANG6 ROLE.MGR
If the query is run by BESSTALMADGE, it displays only the following rows:
User Name ROLE_NAME DEFAULT_ROLE
-------------------- ------------- ------------
BESSTALMADGE ROLE.ROLE002 Yes
BESSTALMADGE ROLE.ROLE003
BESSTALMADGE ROLE.ROLE004
Roles Defined on Neoview (HP_SECURITY.NEOROLES)
The NEOROLES view consists of one row per role. At any given time, this view reflects all roles
defined on the Neoview platform. It includes platform user IDs such as SUPER.SERVICES.
This view is accessible only to users assigned the role ROLE.SECMGR or ROLE.MGR. A user
who is assigned the role ROLE.SECMGR can grant access to other users.
Column Definitions
Each row consists of the following columns:
Table 6-3 VIEW NEO.HP_SECURITY.NEOROLES
Example of ValueDescriptionTypeColumn Name
ROLE.DBARole nameCHAR(128)ROLE_NAME
256Numerical identifier
corresponding to the role
INTEGERROLE_ID
Example Queries
This query lists all the roles defined on the Neoview platform:
select substring(user_name,1,20) as "Role Name",
role_id from hp_security.neoroles;
Role Name ROLE_ID
-------------------- -----------
ROLE.DBA 257
ROLE.USER 258
ROLE.DEBBY 259
ROLE.ROLE001 260
ROLE.M3MROLE 261
ROLE.ROLE002 262
ROLE.ROLE003 263
ROLE.ROLE004 264
ROLE.ROLE005 265
ROLE.ROLE006 266
ROLE.MYROLE 267
ROLE.MYROLE1 268
ROLE.MYROLE2 269
ROLE.MYROLE3 270
ROLE.GEORG 276
ROLE.MARTY 298
ROLE.B 300
ROLE.JACK 306
ROLE.JACK2 307
ROLE.TESTTUBE 308
ROLE.RLGP0005 309
ROLE.RLGP0006 310
ROLE.MAX 342
ROLE.A 354
ROLE.WENDELL 355
ROLE.SECMGR 510
Database Security Views 135