REVOKE Statement

The REVOKE statement revokes access privileges for a SQL/MX table, view, MV, schema, sequence generator, or stored procedure from specified users.

REVOKE [GRANT OPTION FOR]
    {privilege [,privilege ]... | { ALL | ALL_DML | ALL_DDL } [PRIVILEGES]}
    ON target
    FROM grantee [,grantee ]... [drop-behavior ]
    [BY authid-grantor] 

grantee is:
   authid | usernumber | PUBLIC

privilege is:
        SELECT
      | DELETE
      | INSERT
      | UPDATE [(column [,column ]...)]
      | REFERENCES [(column [,column ]...)]
      | USAGE
      | EXECUTE
      | CREATE
      | ALTER
      | DROP

grantee is:
   authid | usernumber | PUBLIC | DB_PUBLIC

target is:
   { object-specification }
   { schema-specification }

object-specification is:
[ TABLE | SEQUENCE | PROCEDURE ] 
object-name

schema-specification is:
   { SCHEMA schema-name }

drop-behavior is:
   CASCADE | RESTRICT