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

schema_priv
from hp_security.neoschemapriv;
Schema Name Role Name SCHEMA_PRIV
------------------------------ -------------------- -----------
DB ROLE.DBA AD
SHAKE2 ROLE.DBA AD
USR ROLE.USER AD
USER_SCH ROLE.USER AD
[e-mail] ROLE.ROLE001 AD
PNELSON1 ROLE.ROLE001 AD
PARK5_SCH ROLE.ROLE001 AD
PNELSON4 ROLE.MYROLE1 AD
SHAKE1 ROLE.SECMGR AD
HP_URI ROLE.MGR AD
HPNCI_SAMPLE ROLE.MGR AD
HP_TEST ROLE.MGR AD
UAF ROLE.MGR E
QA_HPDM_TEST SUPER.SERVICES AD
SERV SUPER.SERVICES AD
HP_METRICS SUPER.SERVICES AD
HP_METRICS_LXP SUPER.SERVICES AD
HP_REPORTING SUPER.SERVICES AD
HP_USTAT SUPER.SERVICES AD
PUBLIC_ACCESS_SCHEMA SUPER.SERVICES AD
HP_PC SUPER.SUPER AD
HP_SECURITY SUPER.SUPER AD
PC_SP SUPER.SUPER AD
VINCENT SUPER.SUPER AD
ODBC_SCHEMA SUPER.SUPER AD
FLAGSTO200904 SUPER.SUPER AD
NLSCHEMA SUPER.SUPER AD
HP_SP SUPER.SUPER AD
UAF SUPER.SUPER AD
If the same query were submitted by any user with ROLE.ROLE001, the output would look like
this:
Schema Name Role Name SCHEMA_PRIV
------------------------------ -------------------- -----------
[e-mail] ROLE.ROLE001 AD
PNELSON1 ROLE.ROLE001 AD
PARK5_SCH ROLE.ROLE001 AD
Database Object Ownership (HP_SECURITY.NEOOBJECTLIST)
The NEOOBJECTLIST view provides a list of database objects in the NEO catalog. For each object,
it indicates schema, the object name, the type of object (for instance, a table, view, or procedure),
and the role that owns the object. This list excludes object in system schemas.
This view is accessible to users assigned the role ROLE.SECMGR, ROLE.MGR, SUPER.SUPER,
SUPER.SERVICES, and ROLE.DBA. Any other user can see objects owned by the role in which
he or she is logged on.
Column Definitions
Each row consists of the following columns:
Table 6-6 VIEW NEO.HP_SECURITY.NEOOBJECTLIST
Example of ValueDescriptionTypeColumn Name
[e-mail] nameCHAR(128)SCHEMA_NAME
HISTOGRAMSObject nameCHAR(128)OBJECT_NAME
138 Database Security