Unified preferences and Subversion

[Jurij]

Hello,

we are at the moment in progress of integration Subversion with the PL/SQL developer.

We would like to eliminate the possibilities of the scenario that developers could change the code directly from PL/SQL developer without changing it in SVN.

So, we think of one possibilities, and that is to disable packages, procedures, functions, from object window and disable setup of Preferences. That way developers are forced to go through the SVN.

Is the following scenario possible ? Is it possible to disable Preferences menu in PLSQL developer?

Anyway, other suggestions are also possible and welcome.

At the moment we are having PL/SQL developer version 9.0.6.

Thanks, Jurij

 

[Marco Kalter]

These kind of restrictions are not possible. To limit the chance that someone accidentally modifies or compiles a source that is not checked out, go to Tools > Preferences > Oracle / Options and disable the following 2 options:

* Allow editing of database source
* Allow compilation of read-only source files

You can additionally use the Authorization function (File > Authorization) to disable specific functions.

 

[Jurij]

Thank you for your reply.
The tip is helpful. We will pursue this solution to configure our environment.