REVOKE

The REVOKE statement removes the privileges on a database object. You can revoke privileges to functions, procecures, packages, tables and user-defined types to a specific user ID or to PUBLIC.

Different objects allow for different types of privileges. 

On function and procedures, you can revoke the following privileges:

On packages, you can revoke the following privileges:

On tables or views, you can revoke the following privileges:

On user-defined types, you can revoke the following privileges:

Example: Function or procedure

Revoke the EXECUTE privilege on procedure CORPDATA.PROCA from PUBLIC.

REVOKE EXECUTE
  ON PROCEDURE CORPDATA.PROCA
  FROM PUBLIC

For more information, see REVOKE (Function and procedure) in the SQL Reference topic in the Information CenterLink to Information center.

Example: Package

Revoke the EXECUTE privilege on package CORPDATA.PKGA from PUBLIC.

REVOKE EXECUTE
  ON PACKAGE CORPDATA.PKGA
  FROM PUBLIC

For more information, see REVOKE (Package) in the SQL Reference topic in the Information CenterLink to Information center.

Example: Table or view

Revoke SELECT privileges on table CORPDATA.EMPLOYEE from user PULASKI.

REVOKE SELECT
  ON CORPDATA.EMPLOYEE
  FROM PULASKI

For more information, see REVOKE (Table) in the SQL Reference topic in the Information CenterLink to Information center.

Example: User-defined type

Revoke the USAGE privilege on distinct type SHOESIZE from user JONES.

REVOKE USAGE
  ON DISTINCT TYPE SHOESIZE
  FROM JONES

For more information, see REVOKE (User-defined type) in the SQL Reference topic in the Information CenterLink to Information center.