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

SQL/MX Statements
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
2-196
Example of GIVE CATALOG
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 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}
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.
GIVE object-type object TO authid