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.
Procedure
To set preferences for privilege management:
- Click to open the Preferences window.
- Expand Data and click Authorization
Administration.
- Modify preferences as needed.
- 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.