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-246
REVOKE CREATE CATALOG Statement

This example revokes the privileges of granting SELECT and DELETE privileges
on a table from two users:
REVOKE GRANT OPTION FOR SELECT, DELETE
ON TABLE sales.odetail FROM "sql.user1", "sql.user2";

This example revokes UPDATE privileges on two columns of a table:
REVOKE UPDATE (start_date, ship_timestamp)
ON TABLE persnl.project FROM PUBLIC RESTRICT;

In this example the super ID revokes SELECT and DELETE privileges on a table
on behalf of sql.user1:
REVOKE SELECT, DELETE ON TABLE sales.odetail
FROM "sql.user3" BY "sql.user1";
REVOKE CREATE CATALOG Statement
Considerations for REVOKE CREATE CATALOG
Examples for REVOKE CREATE CATALOG
The REVOKE CREATE CATALOG revokes the privilege to create a catalog from
specified users.
{"grantee" [,"grantee"]...}
are Guardian users from whom the catalog creation privilege will be revoked.
Considerations for REVOKE CREATE CATALOG
When CREATE CATALOG privilege is revoked from the last authorized user, any user
can create a catalog.
Authorization and Availability Requirements
A 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) can revoke the
privilege to create a catalog granted to specified users.
CREATE CATALOG privilege cannot be revoked from PUBLIC.
Examples for REVOKE CREATE CATALOG

This example revokes the privilege to create a catalog from users, “SQL.USER1”,
“SQL.USER2”, and “SQL.USER3”:
REVOKE CREATE CATALOG FROM {"grantee" [,"grantee"]...}