<< REVOKE statement | Syntax for user-defined types >>

Syntax for sequence generators

<< REVOKE statement | Syntax for user-defined types >>

Derby Reference Manual

Syntax for routines

REVOKE EXECUTE ON { FUNCTION | PROCEDURE }

routine-designator

FROM

grantees

RESTRICT

You must use the RESTRICT clause on REVOKE statements for routines. The
RESTRICT clause specifies that the EXECUTE privilege cannot be revoked if the
specified routine is used in a view, trigger, or constraint, and the privilege is being
revoked from the owner of the view, trigger, or constraint.

Syntax for sequence generators

REVOKE USAGE ON SEQUENCE [

schemaName

. ]

SQL92Identifier

FROM

grantees

RESTRICT

In order to use a sequence generator, you must have the USAGE privilege on it. This
privilege can be revoked from users and roles. Only RESTRICTed revokes are allowed.
This means that the REVOKE statement cannot make a view, trigger, or constraint
unusable by its owner. The USAGE privilege cannot be revoked from the schema owner.
See

CREATE SEQUENCE statement

for more information.

The sequence name is composed of an optional schemaName and a SQL92Identifier. If
a schemaName is not provided, the current schema is the default schema. If a qualified
sequence name is specified, the schema name cannot begin with SYS.

Syntax for user-defined types

REVOKE USAGE ON TYPE [

schemaName

. ]

SQL92Identifier

FROM

grantees

RESTRICT

In order to use a user-defined type, you must have the USAGE privilege on it. This
privilege can be revoked from users and roles. Only RESTRICTed revokes are allowed.
This means that the REVOKE statement cannot make a view, trigger, or constraint
unusable by its owner. The USAGE privilege cannot be revoked from the schema owner.
See

CREATE TYPE statement

for more information.

The type name is composed of an optional schemaName and a SQL92Identifier. If a
schemaName is not provided, the current schema is the default schema. If a qualified
type name is specified, the schema name cannot begin with SYS.

Syntax for roles

REVOKE

roleName

[ {,

roleName

}* ] FROM

grantees

Only the

database owner

can revoke a role.

privilege-types

ALL PRIVILEGES |
privilege-list

privilege-list

table-privilege {, table-privilege }*

table-privilege

column list