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-235
Examples for REVOKE CREATE CATALOG
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 "SQL.USER1";
REVOKE CREATE CATALOG FROM "SQL.USER2","SQL.USER3";
REVOKE CREATE SCHEMA Statement
Considerations for REVOKE CREATE SCHEMA
Example for REVOKE CREATE SCHEMA
The REVOKE CREATE SCHEMA revokes the privilege to create a schema in a
catalog from specified users.
catalog
is the name of the catalog in which the schema creation privilege will be revoked.
{"grantee" [,"grantee"]...}
are Guardian users from whom the schema creation privilege on the catalog will
be revoked.
Considerations for REVOKE CREATE SCHEMA
When CREATE SCHEMA privilege is revoked from the last authorized user, any user
can create a schema in the target catalog.
Authorization and Availability Requirements
A security administrator or catalog owner 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 granted to specified users from creating a schema within the
catalog.
CREATE SCHEMA privilege cannot be revoked from PUBLIC.
Example for REVOKE CREATE SCHEMA
•
This example revokes the privilege to create a schema from users, “SQL.USER1”
and “SQL.USER2”:
REVOKE CREATE SCHEMA ON CAT FROM "SQL.USER1", "SQL.USER2";
REVOKE CREATE SCHEMA ON catalog FROM {"grantee"
[,"grantee"]...}