DB2 graphic  QMF Version 8

Using the SQL REVOKE statement

Use the SQL REVOKE statement to remove privileges:

Figure 23. Revoking an SQL privilege from a QMF user
REVOKE UPDATE ON ORDER__BACKLOG FROM JONES

Use the PUBLIC keyword to revoke privileges from all QMF users.

DB2 privileges have a cascading structure; privileges revoked from a user are automatically revoked from any additional users to whom that user granted them.


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