How to revoke database grants

Previous Next

To revoke database grants:

1.Choose Tools, Revoke All Table Rights.

The Revoke All Table Rights dialog appears.

2.Complete the dialog as follows:

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.

3.Click OK to apply the revoke and close this window, or Apply to apply the revoke, and then specify another one.

 

See Also

Database Grants