Enables you to remove
explicitly granted or denied privileges from the specified object.
REVOKE { { "objectpriv" | "containerpriv" |
"serverpriv" [,...] } |[ ON { SCHEMA "schemaname" | CATALOG "catalogname" |
[DATA] SERVICE "servicename" | DSN "dsnname" | SERVER} ]FROM { "authid" | PUBLIC | USERS } [, ...]
“objectpriv
Specifies the name
of an object–level privilege to grant or deny, as one of the
following values:
“containerpriv”
Specifies the name
of a container–level privilege to grant or deny, as one of
the following values:
“serverpriv”
Specifies the name
of the server–level privilege to grant or deny, as one of the
following values:
“schemaname”
Specifies the name
of the schema.
“catalogname”
Specifies the name
of the catalog.
“servicename”
Specifies the name
of the data service
“dsnname”
Specifies the name
of the DSN.
“authid”
Specifies the user
or group name for which the privileges are granted or denied.
AS ADMINISTRATOR
Grants privileges using
the ADMINISTRATOR role. Without this, the privilege is granted as
the individual user.
Note: If the user is a system user,
then privileges are assigned with SYSTEM as the grantor.
REVOKE ALL ON SCHEMA "BASE_CATALOG1"."schema1_BASE" FROM "user1"
REVOKE INSERT ON DATA SERVICE BASE FROM "USER1"
REVOKE all on server from "user1"