SQL Statements › CREATE TABLE › Privileges

Privileges

If the Multi-User Facility is secured, whether the creator of the table may access that table depends on the security model of the table. Under the SQL Security Model, when a table is created the user who executes the CREATE TABLE statement is automatically granted all privileges on the table. Under the CA Datacom/DB External Security Model, all access rights, including those for the creator of a table, must be defined through the external security product. See the CA Datacom Security Reference Guide for more information.

The CREATE TABLE statement cannot create a remote, partitioned or replicated table. For remote tables, a complete duplicate definition of a remote table in CA Datacom Datadictionary is required for SQL access, and no version control enforcement is available to ensure that remote definitions are synchronized with the local active definition.