SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-236
GIVE Object Statement
GIVE Object Statement
Considerations for GIVE Object
Examples of GIVE Object
The GIVE object statement transfers the ownership of the object from one Guardian
user to another.
object-type
specifies the type of the object whose ownership will be changed. The object type
can be one of the following:
{TABLE | TRIGGER | VIEW | PROCEDURE | SEQUENCE}
object
specifies the name of the object whose ownership will be changed. The object
name can either be fully qualified or partially qualified. If the name is not fully
qualified, the object name is resolved based on default catalog and schema
names.
authid
specifies an authorization ID to whom the ownership is transferred. Authorization
IDs identify users during the processing of SQL statements. The authorization ID
must be a valid Guardian user name, enclosed in double quotes. A Guardian user
number (for example, “255,255”) is not allowed. authid is not case-sensitive.
Considerations for GIVE Object
The GIVE TABLE operation will change the ownership of associated indexes, trigger
temporary table and constraints to the new owner.
The GIVE VIEW operation will not change the ownership of underlying tables.
Object Feature Version (OFV) of the object is increased to 3100, if the schema owner
and object owner are different after the completion of the operation. However, after
completion of the operation, if the schema owner and the object owner happen to be
the same again, then the OFV is recomputed and set.
Authorization and Availability Requirements
The GIVE operation on a Table, View, Procedure, Trigger and Sequence Generator
can be performed by schema owner or object owner or security administrator or the
Super ID (if Super ID is part of the Security Administrator’s group or if no Security
Administrator’s group exists). The ownership of an object cannot be transferred to
PUBLIC. The ownership of an object cannot be transferred to any member of the
Security Administrator’s group, unless the GRANTOR is the object owner or the
GIVE object-type object TO authid