SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
5-29
GIVE SCHEMA Operation
metadata, then execute the TMF RECOVER FILES command to recover the label,
data, and resource forks.
The metadata will now have a new object UID and the label information will have
the old object UID. When you perform a VERIFY on this file, because the UID
value in the metadata tables does not match the UID value in the resource fork.,
you receive this message:
20799 The { catalog | schema | object } UID in the resource
fork (value) does not match the UID (value) in the metadata
for Guardian file (filename).
Run FIXUP to make the UID value in the resource fork match the UID value in the
metadata:
mxtool FIXUP TABLE mycat.mysch.FIXUPtable -ru -d
GIVE SCHEMA Operation
Considerations for GIVE SCHEMA
Examples of GIVE SCHEMA
The GIVE SCHEMA operation transfers the ownership of the schema and optionally,
the objects owned by the schema owner from one user to another.
schema
specifies the schema on which the GIVE operation is performed.
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.
CASCADE
specifies whether the ownership changes are cascaded to the objects owned by
the schema owner within the schema.
Considerations for GIVE SCHEMA
The ownership of user metadata tables in the schema is transferred to the new owner
irrespective of the CASCADE option.
If the schema owner and object owner are different after the completion of the
operation, the Object Feature Version (OFV) of the objects within the schema is
increased to 3100. However, if after completion of the operation, the schema owner
and object owner are the same again, then the OFV is recomputed and set.
GIVE SCHEMA schema TO authid [CASCADE]