How to revoke database grants
To revoke database grants:
The Revoke All Table Rights dialog appears.
•Fill in the Application field as required, or click the Lookup button to choose one from the list that appears.
•Fill in the User field as required, or click the Lookup button to choose one from the list that appears. If you leave this field empty, all users of the application will have their rights revoked.
•Check or clear the From file checkbox to indicate whether you want the definitions of the application read from the flat file on your computer, or from the repository in which the application was developed.
•If you want the revoking of the grants to be sent directly to the database, leave the Output File field empty. If you want the necessary statements to be put in a script file, type a filename, or use the Browse button. The file will be created in your HOME directory.