some handling questions (newbie)

[jko]

Hi,

I'm evaluating PL/SQL-Developer atm and I have to say - it's an awesome tool. I was about to post some things earlier but figured out how to do it in PL/SQL-Developer so maybe this question is one of this kind, too.

Is there a way to grant permissions (execute) on a sys-Package to another user using the IDE? I can handle permissions on a table but I didn't found this option for packages (yet).

Another question about the source code handling. I have to say, we are currently "developing" our little application without "external" scripts but on the direct way in the database (SQL-Developer ) but we want to use subversion version control. In the manual there is a note that PL/SQL Developer is focused on development with "external" files.

So: how do I do it? I know how to store an altered package into the database, but how do I go "the proper way"? I connect to our development user and see my packages, procedures and stuff. I save the package on a local harddrive. Is the PL/SQL Developer doing all the handling by itself? So user wants to edit pkg_test in PL/SQL Developer -> PL/SQL Developer opens file pkg_test.bdy ...? Or how does it work?

Thank you in advance

 

[Marco Kalter]

Is there a way to grant permissions (execute) on a sys-Package to another user using the IDE? I can handle permissions on a table but I didn't found this option for packages (yet).

This can be done from the context of the User. Right-click on the user in the Object Browser, select "Edit", and go to the "Object privileges" tab page to grant/revoke object privileges.

So: how do I do it?

If you want to work with files, and even with a version control system, then you need to ensure that only files are edited. Therefore you need to prevent that objects are modified directly in the database. You can do so by using the Authorization function to specifically grant PL/SQL Developer functions, or simply by disabling the "Allow editing of database source" and "Allow compilation of read-only source files" preferences (Tools > Preferences > Oracle / Options).