Disabling PL/SQL Program Unit Editing

Previous

Next

By default, developers can change and compile PL/SQL source code when browsing database procedures, packages, and functions in Object Browser. You can disable PL/SQL program unit editing by selecting Do not allow PL/SQL program unit editing on the Preferences page.

To disable PL/SQL program unit editing:

1. Navigate to the Workspace home page.

2. Click Manage Services on the Administration list.

   The Manage Services page appears.

3. Click Preferences.

   The Preferences page appears.

4. Under PL/SQL Editing, select one of the following:

   • Allow PL/SQL program unit editing

   • Do not allow PL/SQL program unit editing

   If you select Do not allow PL/SQL program unit editing, developers can still create and replace PL/SQL program units using scripts or SQL Commands.