Neoview SQL Reference Manual (R2.2)
Database Objects
A database object is an SQL entity that exists in a namespace, maps to a file in most cases, and
is registered in the system catalog. DML statements can access Neoview SQL objects. The
subsections listed below describe these Neoview SQL objects.
“Constraints”
“Indexes”
“SQL Tables”
“Tables”
“Views”
Ownership
In Neoview SQL, the creator of a schema owns all the objects defined in the schema. In addition,
you can use the GRANT and REVOKE statements to grant access privileges for a table or view
to specified users.
For more information, see “Security” (page 29), “GRANT SCHEMA Statement” (page 119), and
“REVOKE Statement” (page 134). For information on privileges on tables and views, see “CREATE
TABLE Statement” (page 69), “ALTER VIEW Statement” (page 51), and “CREATE VIEW
Statement” (page 87).
Database Objects 195