Neoview SQL Reference Manual (R2.3)

• ALTER - Can modify the definition of the objects in the schema.
• 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.
• CREATE - Can create objects in the schema and become the object's owner.
• CREATE_TABLE - Can create tables in the schema and be the owner of the table.
• CREATE_VIEW — Can create regular views in the schema and become the view owner.
• ALL - Can have all privileges (SELECT, DELETE, INSERT, UPDATE, EXECUTE, and
REFERENCES) that apply to the object type.
• ALL_DDL - Any table, view, materialized view, or procedure created in the schema after
this privilege is granted will be able to perform any DDL privilege, including all variants
of CREATE, DROP, ALTER, and MAINTAIN.
• ALL_DML - Any table, view, materialized view, or procedure created in the schema after
this privilege is granted will be able to perform any DML privilege, including DELETE,
EXECUTE, INSERT, REFERENCES, SELECT, or UPDATE.
General Rules for column-list
Names the columns to which the SELECT, UPDATE, or REFERENCES privileges apply. If you
specify SELECT, UPDATE or REFERENCES without column names, the privileges apply to all
columns of the table or view (regular or materialized).
256 SQL Language Elements