ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 303
SQL Statements A - D
ALTER TABLE
constraint was defined.
SQL Syntax—SetTypeSpecification
SET TYPE {PRIVATE
PUBLICREAD
PUBLIC
PUBLICROW }[RESET AUTHORITY
PRESERVE AUTHORITY]
Parameters—SetTypeSpecification
PRIVATE enables the table to be used by only one transaction at a time. Locks are
applied at the table level. This is the most efficient option for tables that do
not need to be shared because ALLBASE/SQL spends less time managing
locks.
If RESET AUTHORITY is specified, the option automatically revokes all
authorities on the table from PUBLIC. Otherwise, the authority on the
table remains unchanged.
PUBLICREAD enables the table to be read by concurrent transactions, but allows no more
than one transaction at a time to update the table. Locks are applied at the
table level.
If RESET AUTHORITYis specified, the option automatically issues GRANT
SELECT on
Owner . TableName to PUBLIC, and revokes all other authorities
on the table from PUBLIC. Otherwise, the authority on the table remains
unchanged.
PUBLIC enables the table to be read and updated by concurrent transactions. The
locking unit is a page. A transaction locks a page in share mode before
reading it and in exclusive mode before updating it.
If RESET AUTHORITYis specified, the option automatically issues GRANT
ALL on
Owner . TableName to PUBLIC. Otherwise, the authority on the table
remains unchanged.
PUBLICROW enables the table to be read and updated by concurrent transactions. The
locking unit is a row. A transaction locks a row in share mode before
reading it and in exclusive mode before updating it.
If RESET AUTHORITYis specified, the option automatically issues GRANT
ALL on
Owner . TableName to PUBLIC. Otherwise, the authority on the table
remains unchanged.
RESET AUTHORITY is used to indicate that the authority on the table should be changed
to reflect the new table type. If not specified, the authority on the table
remains unchanged.
PRESERVE AUTHORITY is used to indicate that the authority currently in effect on the
table should be preserved. This is the default.