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

Table 6-7 VIEW NEO.HP_SECURITY.NEOOBJECTPRIV (continued)
Example of ValueDescriptionTypeColumn Name
ROLE.ACCTGRoleCHAR(128)ROLE_NAME
INSERTPrivilege type:
SELECT
INSERT
DELETE
UPDATE
REFER
EXECUTE (for stored
procedures)
AB - ALTER_TABLE
AM - ALTER_MV
AS - ALTER_SYNONYM
AV - ALTER_VIEW
T - TRIGGER
M - MAINTAIN
RF - REFRESH
RO - REORG
US - UPDATE_STATS
CHAR(10)OBJECT_PRIV
Example Queries
The following query lists the privileges for all object 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,15) as "Schema Name",
substr(object_name, 1,15) as "Object Name",
object_type,
substr(role_name,1,17) as "Role Name",
object_priv
from hp_security.neoobjectpriv;
Schema Name Object Name OBJECT_TYPE Role Name OBJECT_PRIV
--------------- --------------- ----------- --------------- ----------
HP_SECURITY NEOROLES VIEW SUPER.SUPER DELETE
HP_SECURITY NEOROLES VIEW SUPER.SUPER INSERT
HP_SECURITY NEOROLES VIEW SUPER.SUPER REFER
HP_SECURITY NEOROLES VIEW SUPER.SUPER SELECT
HP_SECURITY NEOROLES VIEW SUPER.SUPER UPDATE
HP_SECURITY NEOROLES VIEW ROLE.SECMGR SELECT
HP_SECURITY NEOROLES VIEW ROLE.MGR SELECT
HP_SECURITY NEOROLES VIEW SUPER.SERVICES SELECT
HP_SECURITY NEOUSERS VIEW SUPER.SUPER SELECT
HP_SECURITY NEOUSERS VIEW ROLE.SECMGR SELECT
HP_SECURITY NEOUSERS VIEW ROLE.MGR SELECT
HP_SECURITY NEOUSERS VIEW SUPER.SERVICES SELECT
HP_SP ADDUSER PROCEDURE SUPER.SUPER EXECUTE
HP_SECURITY SCHEMALIST VIEW SUPER.SUPER SELECT
HP_SECURITY SCHEMALIST VIEW ROLE.DBA SELECT
HP_SECURITY SCHEMALIST VIEW ROLE.SECMGR SELECT
HP_SECURITY SCHEMALIST VIEW ROLE.MGR SELECT
HP_SECURITY SCHEMALIST VIEW SUPER.SERVICES SELECT
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
Database Security Views 141