Neoview SQL Reference Manual (R2.4 SP2)

• INSERT - Can use INSERT statement.
• UPDATE - Can use UPDATE statement.
• EXECUTE - Can use EXECUTE statement.
• REFERENCES - Can create constraints that reference the object.
• ALL PRIVILEGES - Can have all privileges (SELECT, DELETE, INSERT, UPDATE, EXECUTE,
and REFERENCES) that apply to the object type.
Privilege Descriptions for Schemas
• SELECT - Can use SELECT statement.
• DELETE - Can use DELETE statement.
• INSERT - Can use INSERT statement.
• UPDATE - Can use UPDATE statement.
• REFERENCES - Can create constraints that reference the object.
• EXECUTE - Can EXECUTE privilege on a schema.
• ALTER - Can modify the definition of the objects in the schema.
• ALTER_MV - Can rename, change attributes, and create, populate, and drop indexes for
any materialized view in the schema.
• ALTER_MV_GROUP - Can change the materialized views that are part of the group to be
refreshed together.
• ALTER_SYNONYM - 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_TABLE - 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_TRIGGER - Can enable and disable triggers on tables in the schema.
• ALTER_VIEW - Can rename regular views in the schema.
• CREATE - Can create objects in the schema and become the object's owner.
• CREATE_MV - Can create materialized views in the schema and become the materialized
view owner.
• CREATE_MV_GROUP - Can create a list to store materialized views that are refreshed
together.
• CREATE_PROCEDURE - Can create a procedure in the schema and become owner of the
procedure. Procedures can only be created through HPDM. For more information, see the
HP Database Manager (HPDM) User Guide.
• CREATE_SYNONYM - Can create synonyms in the schema and become the owner of the
synonyms.
• CREATE_TABLE - Can create tables in the schema and be the owner of the table.
• CREATE_TRIGGER - Can create triggers in the schema and become the owner of the triggers.
• CREATE_VIEW - Can create regular views in the schema and become the view owner.
• DROP - 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_MV - 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_GROUP - Can drop MV groups.
• DROP_PROCEDURE - Can drop any procedure in the schema. Procedures can only be
created through HPDM. For more information, see the HP Database Manager (HPDM) User
Guide.
• DROP_SYNONYM - Can drop any synonym in the schema.
Privileges 289