ALLBASE/SQL Reference Manual (36216-90216)

576 Chapter12
SQL Statements S - Z
TRANSFER OWNERSHIP
TRANSFER OWNERSHIP
The TRANSFER OWNERSHIP statement makes a different user or authorization group or
class name the owner of a table, view, procedure, or authorization group.
Scope
ISQL or Application Programs
SQL Syntax
TRANSFER OWNERSHIP OF {[TABLE][ Owner. ] TableName
[VIEW][ Owner. ] ViewName
PROCEDURE [ Owner. ] ProcedureName
GROUP GroupName } TO NewOwnerName
Parameters
[TABLE][ Owner .] TableName is the name of a table to transfer. All indexes, constraints
and rules are also transferred.
[VIEW] [
Owner .] ViewName is the name of a view to transfer.
PROCEDURE [
Owner .] ProcedureName is the name of a procedure to transfer.
GROUP
GroupName is the name of an authorization group to transfer.
NewOwnerName designates the new owner. The new owner can be a user or an
authorization group or a class name.
Description
• The TRANSFER OWNERSHIP statement may invalidate stored sections. Refer to the
ALLBASE/SQL Databast Administration Guide for additional information on the
validation of stored sections.
• You cannot use this statement on system tables or system views.
• Transferring ownership of a table changes the owner's grants to have the new owner as
grantor.
• Transferring ownership of a table drops any views based on the table as well as
revoking all authorities related to the views.
• Indexes and rules are owned by the owner of the table with which they are associated.
When the owner of a table is transferred, then the owner of the indexes and rules
associated with it are automatically transferred.
Authorization
You can transfer ownership of a table, view, procedure, or authorization group if you have
OWNER authority for that table, view, procedure, or group, or if you have DBA authority.