ALLBASE/SQL Reference Manual (36216-90216)

Chapter 12 577

SQL Statements S - Z

TRANSFER OWNERSHIP

Transfers of ownership for tables involving referential constraints are subject to the

following additional considerations:

• The new owner must have the REFERENCES or DBA authorities necessary to allow

ownership of a table containing such constraints. If the new owner does not have the

needed authorities, the transfer is not allowed.

• The name of any constraint or rule deﬁned on the table must not already be in use by

the new owner.

• The new owner is dependent on these authorizations for the duration of the ownership

(the old dependencies are dropped). The authorities cannot be removed from the new

owner by the REVOKE, REMOVE FROM GROUP, or DROP GROUP statements.

Example

CREATE PUBLIC TABLE Parts

(PartNumber CHAR(16) NOT NULL,

PartName CHAR(30),

SalesPrice DECIMAL(10,2))

IN WarehFS

The table is owned by the DBEUserID of its creator.

TRANSFER OWNERSHIP OF Parts TO PurchDB

Now the table is owned by the class named PurchDB.