Using the SQL REVOKE statement

Use the SQL REVOKE statement to remove privileges:

Figure 79. 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.

[ Previous Page | Next Page | Contents | Index ]