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

SQL/MX Statements

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

2-203

GIVE CATALOG Statement

Considerations for GIVE CATALOG

Example of GIVE CATALOG

The GIVE CATALOG statement transfers the ownership of catalog from one Guardian

user to another.

catalog

is an SQL identifier that specifies the name of a catalog.

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 CATALOG

Object Feature Version of the objects under the catalog is not changed as part of this

operation.

Authorization and Availability Requirements

The GIVE CATALOG operation can be performed by a catalog 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 a catalog cannot be

transferred to PUBLIC. The ownership of a catalog cannot be transferred to any

member of the Security Administrator’s group unless the GRANTOR is the owner of

the catalog. The Catalog ownership change does not invalidate the existing opens on

the objects in the schemas residing in the catalog. After successful completion of the

GIVE CATALOG operation, only the new owner can drop a catalog.

Example of GIVE CATALOG



This example transfers the catalog ownership to “SQL.USER1”.

>>give catalog usercat to "sql.user1";

--- SQL operation complete.

GIVE CATALOG catalog TO authid