Setting preferences for privilege management

You can use the Data Object editor to 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 in the Data Object editor.

To set preferences for privilege management:

  1. Click Window > Preferences to open the Preferences window.
  2. Expand Data and click Authorization Administration.
  3. Modify preferences as needed. You can modify the following option:

    For Informix® Dynamic Server (IDS), you can specify to use the AS clause to issue GRANT or REVOKE as a different user.

  4. Click OK to apply your changes and close the Preferences window.
The next time that you modify privileges in the Data Object editor your preferences are used.

Feedback