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.
About this task
To set preferences for privilege management:
- Click to open the Preferences window.
- Expand Data and click Authorization
Administration.
- 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.
- Click OK to apply your changes and
close the Preferences window.
Results
The next time that you modify privileges in the Data Object
editor your preferences are used.