Setting preferences for managing privileges

You can grant, revoke, and modify privileges for data objects. Use the Authorization Administration page of the Preferences window to set preferences for privilege management DDL generation.

Procedure

To set preferences for privilege management, complete the following steps:

  1. Click Window > Preferences to open the Preferences window.
  2. Expand Data Management and click Authorization Administration.
  3. Modify preferences as needed.
  4. Click OK to apply your changes and close the Preferences window.

Results

The next time that you generate a DDL script, the options that you selected are used.

Feedback