Using PL/SQL Developer in Cyberark PAM

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

Using PL/SQL Developer in Cyberark PAM

L2 Linker

I am using Cyberark PAM 12.6.5. I want to use PL/SQL Developer through Cyberark to control the connection to the Oracle database.

I have no experience with this. Technical groups are writing about the need to prepare an AutoIt3 script.

Can anyone who has written and used this script share with me? I don't know anything about how to use the script, what settings (what platform to use, what connection component to use) in cyberark pvwa. Can anyone help me with this problem? I look forward to any help. Thank you!

 

 

 

Field_Content_versions_oct20__068Ht00000VeHYWIA3.png 

Field_Content_versions_oct20__068Ht00000VeHYbIAN.png 

Field_Content_versions_oct20__068Ht00000VeHYgIAN.png

5 REPLIES 5

L6 Presenter

I believe there's a connector available for SQL developer on the marketplace that supports versions 12.2 and above, you could use that. For instructions on how to set it up, please take a look at this CyberArk doc: https://docs.cyberark.com/pam-self-hosted/Latest/en/Content/PASIMP/PSM_Oracle_SQL.htm?tocpath=Administrator%7CComponents%7CPrivileged%20Session%20Manager%7CPSM%20Connectors%7CDatabases%7C_____5

L7 Applicator
  1. AutoIt3 Script: You’ll need to create an AutoIt3 script that automates the login process for PL/SQL Developer. This script should handle entering the username, password, and any other required fields. You can find examples and guidance on creating these scripts in the CyberArk community forums12.
  2. Connection Component: In CyberArk’s PVWA (Privileged Web Access), you need to configure a connection component that uses your AutoIt3 script. This involves specifying the path to the AutoIt3 executable and your script file. Detailed instructions on configuring PSM connections can be found in CyberArk’s documentation3.
  3. Platform Settings: Depending on how your users authenticate, you might need to choose the appropriate platform in PVWA. For example, if users authenticate with Active Directory accounts, select the Active Directory platform. If they use database accounts, select the appropriate database platform1.

 

 

 

Cyberark has training on how to create connectors

L5 Sessionator

If you have been using local users to get connected, then follow the exact process for sql developer PSM Plugins described in 14.2 document irrespective of any versions of cyberark you have. If domain users then it will have little scripts with few modifications.

L0 Member

The scenario i had was with local db authentication.

I created a connection component with the following configuration as clone of the Oracle SQL developer connection component.

Field_Content_versions_oct20__068Vy00001EkQGhIAN.pngI used command line target settings as below.

Field_Content_versions_oct20__068Vy00001Ekf2nIAB.pngCMDLINE: "C:\Program Files (x86)\PLSQL Developer\plsqldev.exe" userid="{UserName}"/"{Password}"@"{Address}":"{Port}"/"{Database}"

 

To note:

  • I installed PLSQL client on the PSM with the tns configuration file pointing to the different instances.
  • During onboaring, I ensured to have "UserName,Password,Address,Database" parameters onboarded.

Field_Content_versions_oct20__068Vy00001EkdtqIAB.png

L2 Linker

Hello,

Have you prepared any AutoIT script to launch PL/SQL Developer?

Could you send the Connection component and platform settings that are currently working on your side?

Thank you in advance.

  • 888 Views
  • 5 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!