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. On the Database Home Page, click the Application Builder icon.

2. From the Administration list, select Manage Services.

3. Click Preferences.

   The Preferences page appears.

4. From 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.