SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Utilities

HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001

5-35

GIVE SCHEMA Operation

Considerations for GIVE SCHEMA

Examples of GIVE SCHEMA

The GIVE SCHEMA operation transfers the ownership of the schema and optionally,

those objects in the schema 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 at

least 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.

Authorization and Availability Requirements

The GIVE SCHEMA operation can be performed by the schema owner or security

administrator or a Super ID (if Super ID is part of the Security Administrator’s group or

if no Security Administrator’s group exists). After successful completion of this

operation, all the existing opens on the underlying objects are invalidated.

Examples of GIVE SCHEMA



This example transfers the schema ownership to “SQL.USER5”:

GIVE SCHEMA schema TO authid [CASCADE]