Does the package support RSA key login?

[rainerkoenigs]

Dear Mr. Scheffer,

in your blog article https://technology.amis.nl/languages/oracle-plsql/finally-sftp-from-an-oracle-database-using-plain-plsql/ from Christmas 2019 you wrote that for the moment only login with username and password is possible with your package as_sftp.

Now, more than 3 years later (not 5 yet 😉) I got the package from github and found the procedure login_pk which seems to implement exactly the feature that you described as missing in your blog article 😊

Can you give me a short hint - does RSA key login work with that procedure?

In any case, you have done a great job with the package!

Thanks in advance for a short answer and best regards from Germany

[antonscheffer]

Short hint: read usage.md
Longer answer: it is indeed possible to login with a RSA, DSA or Elliptic Curve (nistp256, nistp384, nistp521) private key.
You can use either the procedure login or login_pk.
For the first you will need to pass the private key as varchar2 parameter, for the second it should be loaded from the filesystem.

[rainerkoenigs]

Thanks for your answer and your great package! Best regards from Germany Rainer Königs Dipl.-Ing. (BA) Technische Informatik Referent IT-Serviceentwicklung Fon: +49 (0)711 97676-414 E-Mail: ***@***.******@***.***> Fax: +49 (0)711 97576-499 Internet-Adresse: http://www.gtue.de<http://www.gtue.de/> GTÜ Gesellschaft für Technische Überwachung mbH Vor dem Lauch 25, 70567 Stuttgart, Deutschland Geschäftsführung: Gabriele Schmidt-Rauße, Thomas Emmert HRB Nr. 9610 Stuttgart From: Anton Scheffer ***@***.***> Sent: Tuesday, April 18, 2023 4:39 PM To: antonscheffer/as_sftp ***@***.***> Cc: Koenigs, Rainer ***@***.***>; Author ***@***.***> Subject: Re: [antonscheffer/as_sftp] Does the package support RSA key login? (Issue #21) Short hint: read usage.md Longer answer: it is indeed possible to login with a RSA, DSA or Elliptic Curve (nistp256, nistp384, nistp521) private key. You can use either the procedure login or login_pk. For the first you will need to pass the private key as varchar2 parameter, for the second it should be loaded from the filesystem. — Reply to this email directly, view it on GitHub<#21 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/A7IZFJZBTZ6Y5ED4ME4UYH3XB2RQFANCNFSM6AAAAAAXCWTVBA>. You are receiving this because you authored the thread.Message ID: ***@***.***>