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-195
GIVE CATALOG Statement
GET ALL SECURITY_ADMINS;
Security Administrators
=======================
SECADMIN.USER1
4,85
--- SQL operation complete.
•
The following example lists the security administrators when the security
administrators group is empty:
GET ALL SECURITY_ADMINS;
--- SQL operation complete.
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
GIVE CATALOG catalog TO authid