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-234
Examples of REVOKE
Examples of REVOKE
•
This example revokes one user’s SELECT privileges on a table:
REVOKE SELECT ON TABLE persnl.employee
FROM "sql.user1" RESTRICT;
•
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.
REVOKE CREATE CATALOG FROM {"grantee" [,"grantee"]...}