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

PNELSON1 LISA TABLE ROLE.ROLE001 UPDATE
...
If the same query were submitted by any user with ROLE.ROLE001 access, the output would
look like this:
Schema Name Object Name OBJECT_TYPE Role Name OBJECT_PRIV
--------------- --------------- ----------- --------------- ----------
PARK5_SCH TAB01 TABLE ROLE.ROLE001 DELETE
PARK5_SCH TAB01 TABLE ROLE.ROLE001 INSERT
PARK5_SCH TAB01 TABLE ROLE.ROLE001 REFER
PARK5_SCH TAB01 TABLE ROLE.ROLE001 SELECT
PARK5_SCH TAB01 TABLE ROLE.ROLE001 UPDATE
PNELSON1 LISA TABLE ROLE.ROLE001 DELETE
PNELSON1 LISA TABLE ROLE.ROLE001 INSERT
PNELSON1 LISA TABLE ROLE.ROLE001 REFER
PNELSON1 LISA TABLE ROLE.ROLE001 SELECT
PNELSON1 LISA TABLE ROLE.ROLE001 UPDATE
Database Column Privileges (HP_SECURITY.NEOCOLUMNPRIV)
The NEOCOLUMNPRIV view consists of one row per privilege per role per column per object
within each schema in the NEO catalog. 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-8 VIEW NEO.HP_SECURITY.NEOCOLUMNPRIV
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
ITEM_DESCColumn nameCHAR(128)COLUMN_NAME
142 Database Security