Neoview SQL Reference Manual (R2.5)

Can rename, change attributes, and create, populate, and drop indexes for any
materialized view in the schema.
ALTER_MV
Can change the materialized views that are part of the group to be refreshed together.ALTER_MV_GROUP
Can alter synonyms in the schema. However, ability to alter a synonym does not give
the grantee privileges on the referenced object. In order to perform operations using
the synonym, privileges must exist for the grantee on the referenced object.
ALTER_SYNONYM
Can add and drop constraints; add, populate, and drop indexes; add, alter, and drop
triggers; modify file attributes; add columns, and rename tables for any table in the
schema.
ALTER_TABLE
Can enable and disable triggers on tables in the schema.ALTER_TRIGGER
Can rename regular views in the schema.ALTER_VIEW
Can create objects in the schema and become the owner of the objects.CREATE
Can create materialized views in the schema and become the materialized view owner.CREATE_MV
Can create a list to store materialized views that are refreshed together.CREATE_MV_GROUP
Can create stored procedures in the schema.
NOTE: To upload and create stored procedures on the Neoview platform, use HPDM.
For more information, see the Neoview Guide to Stored Procedures in Java and the HP
Database Manager (HPDM) User Guide.
CREATE_PROCEDURE
Can create synonyms in the schema and become the owner of the synonyms.CREATE_SYNONYM
Can create tables in the schema and be the owner of the table.CREATE_TABLE
Can create triggers in the schema and become the owner of the triggers.CREATE_TRIGGER
Can create regular views in the schema and be the view owner.CREATE_VIEW
Can use DELETE statement.DELETE
Explicit drop of all objects, including DROP_MV, DROP_MV_GROUP,
DROP_SYNONYM, DROP_TABLE, DROP_TRIGGER, and DROP_VIEW. The grantee
can drop any object in the schema.
DROP
Can drop any materialized view in the schema. Indirectly allows the grantee to drop
any dependent object on the materialized view, such as synonyms and indexes.
DROP_MV
Can drop materialized view groups.DROP_MV_GROUP
Can drop stored procedures in the schema.
NOTE: To drop stored procedures on the Neoview platform, use HPDM. For more
information, see the Neoview Guide to Stored Procedures in Java and the HP Database
Manager (HPDM) User Guide.
DROP_PROCEDURE
Can drop any synonym in the schema.DROP_SYNONYM
Can drop any table (regular or volatile) in the schema. Indirectly allows the grantee
to drop any dependent object on the table such as constraints, indexes, triggers, and
synonyms.
DROP_TABLE
Can drop any trigger in the schema.DROP_TRIGGER
Can drop any regular view in the schema.DROP_VIEW
Can EXECUTE privilege on a schema.EXECUTE
Can use INSERT statement.INSERT
Can create constraints that reference objects within the schema.REFERENCES
Can use SELECT statement.SELECT
Can use UPDATE statement.UPDATE
All of the privileges above. Can have all privileges that apply to the object type.ALL PRIVILEGES
ON SCHEMA schema-name
specifies a schema on which to grant privileges.
GRANT SCHEMA Statement 141