[JIRA] (JENKINS-55736) Support proxy logins

[jonathan.whitby@simplyhealth.co.uk (JIRA)]

Jonathan Whitby created an issue

Jenkins / JENKINS-55736 Support proxy logins Issue Type: New Feature Assignee: Fernando Boaglio Components: sqlplus-script-runner-plugin Created: 2019-01-22 18:06 Environment: v 2.x Priority: Minor Reporter: Jonathan Whitby It would be fantastic if the SQLPlus Script Runner plugin supported proxy logins. Current login syntax is: sqlplus -L user/password@DB @script.sql In this syntax the user credentials are stored in the Jenkins store. What I need is syntax of the form: sqlplus -L proxyuser[proxieduser]/password@DB @script.sql In this syntax the credentials of proxyuser could be stored in the Jenkins store and the identity of proxieduser is provided as an option maybe? Your consideration of this feature enhancement would be appreciated. Add Comment

This message was sent by Atlassian Jira (v7.11.2#711002-sha1:fdc329d)

[fernando@boaglio.com (JIRA)]

Fernando Boaglio closed an issue as Won't Fix

Sorry, this plugin is just a SQL*Plus wrapper.

Jenkins / JENKINS-55736 Support proxy logins

Change By: Fernando Boaglio Status: Open Closed Resolution: Won't Fix

Add Comment

[jonathan.whitby@simplyhealth.co.uk (JIRA)]

Jonathan Whitby commented on JENKINS-55736

Re: Support proxy logins Yes, which is why I am asking for the plugin to support SQL*Plus proxy login syntax. SQL*Plus allows users to connect on behalf of another user. See this Oracle documentation: https://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_twelve015.htm#SQPUG036 From the docs:- proxyuser[username] [/password] [@connect_identifier] Note: The brackets around username in proxy are required syntax, not an indication of an optional term. For example, to connect to scott through proxy user hr with password welcome1. CONNECT hr[scott]/welcome1

Add Comment

[jonathan.whitby@simplyhealth.co.uk (JIRA)]

Jonathan Whitby edited a comment on JENKINS-55736

Re: Support proxy logins

Yes, which is why I am asking for the plugin to support SQL*Plus proxy login syntax.  SQL*Plus allows users to connect on behalf of another user.  See this Oracle documentation: https://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_twelve015.htm#SQPUG036

{quote} From the docs:- {quote}

proxyuser[username] [/password] [@connect_identifier] Note: The brackets around username in proxy are required syntax, not an indication of an optional term. For example, to connect to scott through proxy user hr with password welcome1. CONNECT hr[scott]/welcome1

{quote}

Add Comment

[jonathan.whitby@simplyhealth.co.uk (JIRA)]

Jonathan Whitby commented on JENKINS-55736

Re: Support proxy logins Fernando Boaglio

Add Comment

[fernando@boaglio.com (JIRA)]

Fernando Boaglio commented on JENKINS-55736

Re: Support proxy logins Have you tried to use proxyuser[proxieduser] in username field ?

Add Comment

[jonathan.whitby@simplyhealth.co.uk (JIRA)]

Jonathan Whitby commented on JENKINS-55736

Re: Support proxy logins Yes, I had tried doing that before logging this ticket. It worked successfully apart from echoing the credentials in the log in plain text. I had assumed it was because my use-case was not fully supported by this plugin and so I logged this ticket. Plain text credentials appearing in the log when using proxyuser[proxieduser] in the username field may in fact be a problem with a different plugin though. Parked this for now.

Add Comment

[fernando@boaglio.com (JIRA)]

Fernando Boaglio commented on JENKINS-55736

Re: Support proxy logins As documented in our Wiki, you can use Mask Passwords Plugin to hide it.

Add Comment

[jonathan.whitby@simplyhealth.co.uk (JIRA)]

Jonathan Whitby commented on JENKINS-55736

Re: Support proxy logins I'll take a look, thank you Fernando Boaglio!

Add Comment