REVOKE All Table Privileges

Revokes from one or more users or groups all definition and access privileges on a specified table-like object.
idms
Revokes from one or more users or groups all definition and access privileges on a specified table-like object.
Authorization
To revoke all table privileges, one of the following must be true:
  • You hold all privileges as grantable privileges on the table-like object.
  • You own the table-like object.
  • You hold DBADMIN privileges for the dictionary that contains the table-like object definition and the database that contains the table-like object data.
  • You hold SYSADMIN privilege.
Syntax
►►─── REVOKE ALL PRIVILEGES ──────────────────────────────────────────────────►    ►─── ON table 
table-name
 ────────────────────────────────────────────────────►               ┌─────────────── , ───────────────┐  ►─── FROM ─▼─┬─ PUBLIC─────────────────────┬─┴───────────────────────────────►◄               └─ 
authorization-identifier
 ──┘
Parameters
 
  • ALL PRIVILEGES
    Revokes the DELETE, INSERT, SELECT, UPDATE, ALTER, CREATE, DROP, and REFERENCES privileges, as applicable, on the table-like object identified in the ON parameter from the users or groups identified in the FROM parameter.
  • ON table table-name
    Identifies the table-like object to which the privileges apply.
    Expanded syntax for
    table-name
    is presented in Notes on Security Statement Syntax.You can wildcard the identifier of
    table-name
    . If you specify
    schema-name
    in
    table-name
    , the wildcard character is valid after the period following
    schema-name
    .
    For more information on wildcarding, see Using a Wildcard.
    If you do not specify
    schema-name
    , it defaults to the current schema in effect for your session.
  • FROM
    Specifies the users or groups from whom you are revoking table privileges.
  • PUBLIC
    Specifies all users.
    The privileges must have been previously given to PUBLIC by means of the GRANT statement.
  • authorization-identifier
    Identifies a user or group.
    The privileges must have been previously given to
    authorization-identifier
    by means of the GRANT statement.
    Expanded syntax for
    authorization-identifier
    is presented in Notes on Security Statement Syntax.
Revoking All Privileges From All Users
The following statement revokes all privileges on all table-like objects in the TEST schema from the group PUBLIC:
revoke all privileges    on test.*    from public;
More Information