How to apply "sqlplus -R 2" in PSM-SQLPlus connector?

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

Welcome Idira to LIVEcommunity!

Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.

Meet Idira

How to apply "sqlplus -R 2" in PSM-SQLPlus connector?

L5 Sessionator

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.

 

 

1 accepted solution

Accepted Solutions

Just added -R 2 in Target setting parameter without inverted commas, and it worked.

View solution in original post

6 REPLIES 6

L7 Applicator

Update the target settings of the PSM connection component config via PVWA, and test it.

Hi Bern, I know that but I am wondering what additional parameter should i configure to set that?

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

I have been helped

Great to hear!

 

Could you please share the solution or the relevant documentation with us?

 

Nivi

Just added -R 2 in Target setting parameter without inverted commas, and it worked.

  • 1 accepted solution
  • 260 Views
  • 6 replies
  • 0 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

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!