Revokes the DELETE, INSERT, SELECT, and UPDATE privileges on the table-like object identified in the ON parameter from the users or groups identified in the FROM parameter.
Revokes the DELETE privilege on the table-like object identified in the ON parameter from the users or groups identified in the FROM parameter.
Revokes the INSERT privilege on the table-like object identified in the ON parameter from the users or groups identified in the FROM parameter.
Revokes the SELECT privilege on the table-like object identified in the ON parameter from the users or groups identified in the FROM parameter.
Revokes the UPDATE privilege on the table-like object identified in the ON parameter from the users or groups identified in the FROM parameter.
Identifies the table-like object to which the access privileges apply.
Note: Expanded syntax for table-name is presented in Notes on Security Statement Syntax.
You can wildcard any identifier in table-name when you grant access on 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.
Specifies the users or groups from whom you are revoking the specified table access privileges.
Specifies all users.
The privileges must have been previously given to PUBLIC by means of the GRANT statement.
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.
|
Copyright © 2014 CA.
All rights reserved.
|
|