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

Table 6-8 VIEW NEO.HP_SECURITY.NEOCOLUMNPRIV (continued)
Example of ValueDescriptionTypeColumn Name
ROLE.ACCTGRoleCHAR(128)ROLE_NAME
REFERPrivilege type:
REFER
UPDATE
CHAR(10)COLUMN_PRIV
Example Queries
The following query lists the privileges for all columns in tables in the NEO catalog, excluding
objects in system schemas. It selects substrings where useful to provide for a compact listing
format:
select substr(schema_name, 1,11) as "Schema Name",
substr(object_name, 1,11) as "Object Name",
object_type,
substr(column_name,1,15) as "Column Name",
substr(role_name,1,17) as "Role Name",
column_priv
from hp_security.neocolumnpriv;
Schema Name Object Name OBJECT_TYPE Column Name Role Name COLUMN_PRIV
----------- ----------- ----------- --------------- ----------------- -----------
PNELSON4 USERDATA TABLE USER_NAME ROLE.MYROLE1 REFER
PNELSON4 USERDATA TABLE USER_NAME ROLE.MYROLE1 UPDATE
PNELSON4 USERDATA TABLE ROLE_ID ROLE.MYROLE1 REFER
PNELSON4 USERDATA TABLE ROLE_ID ROLE.MYROLE1 UPDATE
PNELSON4 USERDATA TABLE ROLE_NAME ROLE.MYROLE1 REFER
PNELSON4 USERDATA TABLE ROLE_NAME ROLE.MYROLE1 UPDATE
PNELSON4 USERDATA TABLE NEOUSER_NAME ROLE.MYROLE1 REFER
PNELSON4 USERDATA TABLE NEOUSER_NAME ROLE.MYROLE1 UPDATE
PNELSON4 LISA TABLE ID ROLE.ROLE001 REFER
PNELSON4 LISA TABLE ID ROLE.ROLE001 UPDATE
PNELSON4 LISA TABLE TEXT ROLE.ROLE001 REFER
PNELSON4 LISA TABLE TEXT ROLE.ROLE001 UPDATE
USER_SCH TAB01 TABLE INTEG1 ROLE.USER REFER
USER_SCH TAB01 TABLE INTEG1 ROLE.USER UPDATE
USER_SCH TAB01 TABLE INTEG2 ROLE.USER REFER
USER_SCH TAB01 TABLE INTEG2 ROLE.USER UPDATE
USER_SCH TAB01 TABLE ONE ROLE.USER REFER
USER_SCH TAB01 TABLE ONE ROLE.USER UPDATE
USER_SCH TAB01 TABLE TEN ROLE.USER REFER
USER_SCH TAB01 TABLE TEN ROLE.USER UPDATE
USER_SCH TAB01 TABLE HUNDRED ROLE.USER REFER
USER_SCH TAB01 TABLE HUNDRED ROLE.USER UPDATE
USER_SCH TAB01 TABLE STRING1 ROLE.USER REFER
USER_SCH TAB01 TABLE STRING1 ROLE.USER UPDATE
USER_SCH TAB01 TABLE STRING2 ROLE.USER REFER
USER_SCH TAB01 TABLE STRING2 ROLE.USER UPDATE
...
If the same query were submitted by any user with ROLE.ROLE001 access, the output would
look like this:
PNELSON4 LISA TABLE ID ROLE.ROLE001 REFER
PNELSON4 LISA TABLE ID ROLE.ROLE001 UPDATE
PNELSON4 LISA TABLE TEXT ROLE.ROLE001 REFER
PNELSON4 LISA TABLE TEXT ROLE.ROLE001 UPDATE
Database Security Views 143