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

Table 6-6 VIEW NEO.HP_SECURITY.NEOOBJECTLIST (continued)
Example of ValueDescriptionTypeColumn Name
TABLE57925792Object type:
TABLE
VIEW
PROCEDURE
SYNONYM
MAT. VIEW
CC - Check constraint
IX - Index
LK - Lock
MD - Module
NN - Not null constraint
PK - Primary key
constraint
RC - Referential
constraint
RG - MV refresh group
object
SL - Schema security label
SP - Stored procedure
TR - Trigger object
TT - Trigger temp table
UC - Unique constraint
CHAR(10)OBJECT_TYPE
ROLE.ACCTGRole that owns the objectCHAR(128)OWNER_NAME
Example Queries
The following query lists the schema name, object name, object type, and owner for each object
in the view. It selects only a substring of each field to provide for a compact listing format:
select substr(schema_name, 1,25) as "Schema Name",
substr(object_name, 1,20) as "Object Name",
object_type,
substr(owner_name,1,20) as "Owner"
from hp_security.neoobjectlist;
Schema Name Object Name OBJECT_TYPE Owner
------------------------- -------------------- ----------- -------------
PNELSON4 HISTOGRAMS TABLE ROLE.MYROLE1
PNELSON4 HISTOGRAMS_FREQ_VALS TABLE ROLE.MYROLE1
PNELSON4 HISTOGRAM_INTERVALS TABLE ROLE.MYROLE1
PNELSON4 MVS_TABLE_INFO_UMD TABLE ROLE.MYROLE1
PNELSON4 MVS_UMD TABLE ROLE.MYROLE1
PNELSON4 MVS_USED_UMD TABLE ROLE.MYROLE1
PNELSON4 USERDATA TABLE ROLE.MYROLE1
HP_SECURITY NEOCOLUMNPRIV VIEW SUPER.SUPER
HP_SECURITY NEOOBJECTLIST VIEW SUPER.SUPER
HP_SECURITY NEOOBJECTPRIV VIEW SUPER.SUPER
HP_SECURITY NEOROLES VIEW SUPER.SUPER
HP_SECURITY NEOSCHEMAPRIV VIEW SUPER.SUPER
HP_SECURITY NEOUSERS VIEW SUPER.SUPER
HP_SECURITY OBJECTLIST VIEW SUPER.SUPER
HP_SECURITY SCHEMALIST VIEW SUPER.SUPER
HP_SECURITY SCHEMAPRIV VIEW SUPER.SUPER
[e-mail] HISTOGRAMS TABLE ROLE.ROLE001
[e-mail] HISTOGRAMS_FREQ_VALS TABLE ROLE.ROLE001
[e-mail] HISTOGRAM_INTERVALS TABLE ROLE.ROLE001
[e-mail] MVS_TABLE_INFO_UMD TABLE ROLE.ROLE001
[e-mail] MVS_UMD TABLE ROLE.ROLE001
[e-mail] MVS_USED_UMD TABLE ROLE.ROLE001
HP_SP ADDROLE PROCEDURE SUPER.SUPER
HP_SP ADDUSER PROCEDURE SUPER.SUPER
Database Security Views 139