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. Log in to Oracle Application Express. See "Logging In to Oracle Application Express" in Oracle Application Express Application Builder User's Guide.

   The Workspace home page appears.

2. Click the Administration icon.

   The Administration page appears.

3. Click Manage Service.

4. Click Set Workspace Preferences.

5. Scroll down to SQL Workshop.

6. 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.

7. Click Apply Changes.