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

ROLE.MGR 511
HP.SDI 65279
SUPER.SERVICES 65281
SUPER.SUPER 65535
--- 31 row(s) selected.
Schemas and Their Owners (HP_SECURITY.SCHEMALIST)
The SCHEMALIST view consists of one row per schema. It includes schemas in all catalogs
except system catalogs. The only catalog currently available to customers is NEO. The list also
excludes the system schema.
This view is accessible to users assigned the role ROLE.SECMGR, ROLE.MGR, SUPER.SUPER,
SUPER.SERVICES, and ROLE.DBA.
Column Definitions
Each row consists of the following columns:
Table 6-4 VIEW NEO.HP_SECURITY.SCHEMALIST
Example of ValueDescriptionTypeColumn Name
NEOCatalog nameCHAR(128)CATALOG_NAME
[e-mail] nameCHAR(128)SCHEMA_NAME
ROLE.ACCTGRole that owns the
schema
CHAR(128)SCHEMA_OWNER
Example Queries
The following query lists the catalog, schema, and owner name for all catalogs and schemas in
the view. It selects only a substring of each field to provide for a compact listing format:
select substr(catalog_name,1,25) as "Catalog Name",
substr(schema_name, 1,30) as "Schema Name",
substr(schema_owner,1,20) as "Owner"
from hp_security.schemalist;
Catalog Name Schema Name Owner
------------------------- ------------------------------ ---------------
NEO DB ROLE.DBA
NEO [e-mail] ROLE.ROLE001
NEO FLAGSTO200904 SUPER.SUPER
NEO HPNCI_SAMPLE ROLE.MGR
NEO HP_METRICS SUPER.SERVICES
NEO HP_METRICS_LXP SUPER.SERVICES
NEO HP_PC SUPER.SUPER
NEO HP_REPORTING SUPER.SERVICES
NEO HP_SECURITY SUPER.SUPER
NEO HP_SP SUPER.SUPER
NEO HP_TEST ROLE.MGR
NEO HP_URI ROLE.MGR
NEO HP_USTAT SUPER.SERVICES
NEO NLSCHEMA SUPER.SUPER
NEO ODBC_SCHEMA SUPER.SUPER
NEO PARK5_SCH ROLE.ROLE001
NEO PNELSON1 ROLE.ROLE001
NEO PNELSON4 ROLE.MYROLE1
NEO PC_SP SUPER.SUPER
NEO PUBLIC_ACCESS_SCHEMA SUPER.SERVICES
NEO QA_HPDM_TEST SUPER.SERVICES
NEO SERV SUPER.SERVICES
NEO SHAKE1 ROLE.SECMGR
NEO SHAKE2 ROLE.DBA
136 Database Security