Setting preferences for physical data modeling privilege management

Use the Authorization Administration page of the Preferences window to set preferences for privilege management DDL generation from a physical data model.

Procedure

To set preferences for physical data modeling privilege management:

  1. Go to the Authorization Administration page of the Preferences window.
    1. Click Window > Preferences.
    2. In the tree, select Data Management > Authorization Administration.
  2. 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.

  3. Click OK to apply your changes and close the Preferences window.

Results

The next time that you modify privileges in a physical data model, your preferences are used.

Feedback