DB2 graphic  QMF Version 8

REVOKE

The REVOKE statement removes authorization allowed by a GRANT statement. The syntax of the REVOKE statement is:

REVOKE operation-list ON tablename FROM user-list

operation-list
Lists one or more of the following, separated by commas: ALTER, DELETE, INSERT, SELECT, UPDATE, or ALL to revoke authorization to do any operations.
tablename
Names the table or view for which the authorization is revoked.
user-list
Lists each user ID with commas between. PUBLIC can be specified in place of user-list. The use of PUBLIC does not revoke a privilege from any user ID for which authorization was specifically granted; such a privilege must also be specifically revoked.

REVOKE and GRANT are similar, with the following exceptions:

The following statement revokes authorization to write SELECT queries using table PERS from user Jacobs:

REVOKE SELECT ON PERS FROM JACOBS

The following statement revokes authorization to update any column in PERS from user HSAM4419:

REVOKE UPDATE ON PERS FROM HSAM4419


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004