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

NEO UAF SUPER.SUPER
NEO USER_SCH ROLE.USER
NEO USR ROLE.USER
NEO VINCENT SUPER.SUPER
Privileges on Schemas in the NEO Catalog (HP_SECURITY.NEOSCHEMAPRIV)
The NEOSCHEMAPRIV view includes one row per privilege per role per schema in the NEO
catalog. For each schema, it indicates the roles and the applicable schema privileges. If multiple
users have privileges with respect to a schema, there will be multiple rows for that schema, and
if a user has multiple privileges, there will be a separate row for each privilege.
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 privileges pertaining to the role in
which he or she is logged on.
Column Definitions
Each row consists of the following columns:
Table 6-5 VIEW NEO.HP_SECURITY.NEOSCHEMAPRIV
Example of ValueDescriptionTypeColumn Name
[e-mail] nameCHAR(128)SCHEMA_NAME
ROLE.ACCTGRoleCHAR(128)ROLE_NAME
ADPrivilege type:
AD - Database
Administrator (all
privileges)
A - ALTER privilege
AB - ALTER_TABLE
AM - ALTER_MV
AS - ALTER_SYNONYM
AT - ALTER_TRIGGER
AV - ALTER_VIEW
C - CREATE
CB - CREATE_TABLE
CM - CREATE_MV
CP -
CREATE_PROCEDURE
CS - CREATE_SYNONYM
CT - CREATE_TRIGGER
CV - CREATE_VIEW
D - DROP
DB - DROP_TABLE
DM - DROP_MV
DP - DROP_PROCEDURE
DS - DROP_SYNONYM
DT - DROP_TRIGGER
DV - DROP_VIEW
M - MAINTAIN
RF - REFRESH
RO - REORG
US - UPDATE_STATS
CHAR(2)SCHEMA_PRIV
Example Queries
The following query lists the schema privileges for all schemas in the NEO catalog. It selects
substrings where useful to provide for a compact listing format:
select substr(schema_name, 1,30) as "Schema Name",
substr(role_name,1,20) as "Role Name",
Database Security Views 137