The "Compile with PL/Scope" action affects only the session user about plscope-utils HOT 5 OPEN

The Compile with PL/Scope... context menu is available on the connection node

and the PL/Scope node

The idea is to provide a PL/Scope quick start for the current schema. You compile the current schema with PL/Scope and then you are able to explore the additional metadata (e.g. under the PL/Scope node). If you decide to use PL/Scope on a regular basis in your development environment you should adjust your deployment process to ensure the deployed code is compiled with PL/Scope.

It's certainly not the idea to compile the whole database with PL/Scope or several chosen schemas on a regular bases via this action.

If you want to compile code by default with PL/Scope you can configure SQL Developer accordingly as the following screenshot shows:

From that point on every compile operation issued from SQL Developer will include by default PL/Scope. In the editor or the oder in other actions such as Compile All... on the Packages node. So there is no need to add the action Compile with PL/Scope on additional nodes.

Of course one could use #OBJECT_NAME# instead of the pseudo column USER in the code of the action. However, with the current scope of the action this has no impact. The USER pseudo columns works also with proxy connections. So, I do not see a reason to change that.

Regarding the scope of the synonym recompilation in the action. It is limited to the current schema. For private synonyms with a predicate on owner and for public synonyms with a predicate on table_owner. That's intended. Especially for public synonyms. The current schema is responsible for those public synonyms and if you want to get the full PL/Scope picture you have to compile them.

To be clear. I do not plan to extend the scope of this extension to cover DBA functionalities or extend the scope to multiple schemas. The scope is just the current connect. Nothing more and nothing less. Therefore I flagged this enhancement request as "wontfix".

from plscope-utils.

So there is no need to add the action Compile with PL/Scope on additional nodes.

The problem is, as of v1.0.0 the action is also made available on PL/Scope nodes of other schemas, by having it on plscope-utils-root nodes in addition to CONNECTION nodes.

	<!-- first item based on title is considered independent of minversion/maxversion -->
	<item connType="Oracle" type="CONNECTION" reload="true" minversion="11.1">
		<title>Compile with PL/Scope...</title>

And:

	<!-- Copy of the previous item. Changed type only. A menu cannot be assigned to multiple nodes. -->
	<item connType="Oracle" type="plscope-utils-root" reload="true" minversion="11.1">
		<title>Compile with PL/Scope...</title>

And that is misleading,

If the intent is to have the scope of the "Compile with PL/Scope" action limited to the schema of the session user ¹, then it should not be available on plscope-utils-root nodes, as those nodes are also present in the subtrees of other schemas.

from plscope-utils.

You are right. Under the Other Users node the PL/Scope node is visible for every other user.

This was not my intention, I think.

I see basically two options:

a) Amend the extension to ensure it is not shown under the Other Users node
b) Ensure the the editors and actions work also under Other Users, e.g. by using #OBJECT_NAME# as you suggested

from plscope-utils.

Enabling it for other users (except Oracle-maintained users, see issue #60) would be convenient for users working with DBA rights and tasked with maintaining multi-schemas applications. That's why I could never imagine that this was not the original intent.

from plscope-utils.

I think implementing b) would be sensible.

from plscope-utils.