Revoke All

Click on this push button to cancel all requests for privileges on the selected schemas, tables, indexes, or views.

Example

Suppose that on the Table page, you use the Grant All push button to request all privileges on TABLE1. Then, before closing the Add User notebook, you decide it would be better to grant only the SELECT and INSERT privileges on this table. To do this, you could:

1. Select TABLE1 in the Table column.

2. Click on Revoke All to reset all Privileges boxes to No.

3. Use the SELECT and INSERT boxes to request the SELECT and INSERT privileges.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]