Neoview User Management and Security Administration Guide (R2.5)
Database Security Views
The views described in this section provide information about database users, roles, and database
privileges. The information available to a user depends on the user's role:
• A user with the role ROLE.MGR or ROLE.SECMGR can see all the data.
• A user with SUPER.SUPER or SUPER.SERVICES privileges can see all the data.
• A user with the role ROLE.DBA can see all the data in views except NEOUSERS and
NEOROLES.
• Other users can see data pertaining to their own user name or role
Database Users Registered on Neoview (HP_SECURITY.NEOUSERS)
The NEOUSERS 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.
Column Definitions
Each row consists of the following columns:
Table 6-2 VIEW NEO.HP_SECURITY.NEOUSERS
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 (Yes if it is,
blank if it isn't)
Yes or NoDEFAULT_ROLE
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,default_role from hp_security.neousers;
User Name ROLE_NAME DEFAULT_ROLE
-------------------- ------------- ------------
ANNENYE ROLE.ROLE001 Yes
BESSTALMADGE ROLE.ROLE002 Yes
BESSTALMADGE ROLE.ROLE003
BESSTALMADGE ROLE.ROLE004
CHESLEY3 ROLE.ROLE001 Yes
CHESLEY3 ROLE.ROLE002 Yes
CHESLEY3 ROLE.ROLE003
DAVELEE5 ROLE.ROLE001 Yes
DAVELEE6 ROLE.ROLE002 Yes
DAVELEE6 ROLE.ROLE003
DAVELEE7 ROLE.ROLE001 Yes
DAVELEE8 ROLE.ROLE002 Yes
DAVELEE8 ROLE.ROLE003
DAVELEE9 ROLE.ROLE001 Yes
ORVILLETANG1 ROLE.ROLE002 Yes
ORVILLETANG1 ROLE.ROLE001
ORVILLETANG1 ROLE.MGR
ORVILLETANG2 ROLE.MGR Yes
ORVILLETANG2 ROLE.ROLE002
ORVILLETANG2 ROLE.ROLE003
ORVILLETANG4 ROLE.DBA Yes
134 Database Security