- Access exclusive content
- Connect with peers
- Share your expertise
- Find support resources
Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.
04-17-2023 02:19 PM
This "sqlplus -R 2" has been provided by DB team. They say that this command restricts spool/queries files to get saved in PSM server. To be more clear, whenever end users use this "sqlplus -R 2" while running sqlplus then they cannot save any files of their queries in local machine. Now, They want me to implement this command in PSM-SQLPlus session so that other DB team end users cannot save file sqlplus output files in PSM Server. Has anyone implemented this command or similar to this command or anything else which will restrict saving their files in their user profiles.
Help Will be appreciated as well as if anyone has any other idea than this to stop/restrict the saving of output files of sqlplus then it will be great help for me.
06-01-2023 07:54 AM
Just added -R 2 in Target setting parameter without inverted commas, and it worked.
04-18-2023 02:22 AM
Update the target settings of the PSM connection component config via PVWA, and test it.
04-18-2023 07:17 AM
Hi Bern, I know that but I am wondering what additional parameter should i configure to set that?
05-29-2023 01:11 AM
Hi @sanjay sah
As the community has not answered this question for some time, could you kindly share if you could resolve this issue and how?
If the issue is still relevant, I would advise raising a ticket with our Support team for further assistance.
Thanks,
Niv
05-31-2023 11:41 PM
Great to hear!
Could you please share the solution or the relevant documentation with us?
Nivi
06-01-2023 07:54 AM
Just added -R 2 in Target setting parameter without inverted commas, and it worked.
Click Accept as Solution to acknowledge that the answer to your question has been provided.
The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!
These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!
The LIVEcommunity thanks you for your participation!

