SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-319
Examples of REVOKE
USAGE privilege to the specified authorization IDs. You cannot revoke privileges from
a user of the system if you have granted privileges to PUBLIC.
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";
•
This example revokes USAGE privilege on a sequence generator from
sql.user2:
REVOKE ALL ON SEQUENCE myseq FROM "sql.user2";
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.
REVOKE CREATE CATALOG FROM {"grantee" [,"grantee"]...}