Disabling PL/SQL Program Unit Editing for a Workspace

By default, developers can change and compile PL/SQL source code when browsing database procedures, packages, and functions in SQL Workshop Object Browser. Workspace administrators 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 Set Workspace Preferences.

   The Set Workspace 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.

5. Click Apply Changes.