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

HP_SP CHECKHEALTHOFOBJECT PROCEDURE SUPER.SUPER
HP_SP CHECKHEALTHOFSCHEMA PROCEDURE SUPER.SUPER
HP_SP DELETEROLE PROCEDURE SUPER.SUPER
HP_SP DELETEUSER PROCEDURE SUPER.SUPER
HP_SP GETMYROLES PROCEDURE SUPER.SUPER
HP_SP GETROLESFORUSER PROCEDURE SUPER.SUPER
HP_SP GRANTROLETOUSER PROCEDURE SUPER.SUPER
HP_SP HISTOGRAMS TABLE SUPER.SUPER
HP_SP HISTOGRAMS_FREQ_VALS TABLE SUPER.SUPER
HP_SP HISTOGRAM_INTERVALS TABLE SUPER.SUPER
If the same query were submitted by any user with ROLE.ROLE001, the output would look like
this:
[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
Database Object Privileges (HP_SECURITY.NEOOBJECTPRIV)
The NEOOBJECTPRIV view consists of one row per privilege per role per object in the NEO
catalog. For each object, it indicates the name, the type, the roles that have privileges, and the
privileges assigned. The list excludes objects 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 data pertaining to the role in which
he or she is logged on.
Column Definitions
Each row consists of the following columns:
Table 6-7 VIEW NEO.HP_SECURITY.NEOOBJECTPRIV
Example of ValueDescriptionTypeColumn Name
[e-mail] nameCHAR(128)SCHEMA_NAME
HISTOGRAMSObject nameCHAR(128)OBJECT_NAME
TABLEObject 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
140 Database Security