Syntax for Securing Database Resources › REVOKE All Table Privileges › Parameters

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.

Note: 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.

Note: For more information about 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.

Note: 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;