Skip to Main Content
Forums

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to setup BasicAuth in ORDS

User_CI7SYSep 23 2021 — edited Sep 23 2021

Hi, I am trying to secure a web service using BasicAuth in ORDS via APEX. But it gives me error 401 Unauthorised. I have tried setting up privileges and roles. While setting up Privilege and pattern, I got this error. As per doc below, it should work but I am unable to understand why pattern doesn't.
https://blogs.oracle.com/cloud-infrastructure/post/ords-basic-authentication-with-oracle-apex
Screenshot 2021-07-06 212234.png

Comments

Gaz in Oz

You will need to supply more information.

. sqlcl version

  sql -v

  or from within sqlcl

  show version

. How do you start the bash shell?

. copy/paste how you start bash. (xterm emulator? cmd.exe? Conemu64?...)

. copy/paste how you start sqlcl

Basically, to help you, you need to show us what you are doing, not just tell us.

For example, up-arrow works for me on windows 10 with bash 3.1:

F:\Oracle>bash
bash-3.1$ sql gaz/gaz@xe
SQLcl: Release 17.2.0 Production on Mon Oct 02 17:45:15 2017
Copyright (c) 1982, 2017, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> show version
Oracle SQLDeveloper Command-Line (SQLcl) version: 17.2.0.184.0917
SQL> -- pressing up arrow
SQL> show version
calinm

Hi,

I start using the shortcut on the desktop:

C:\cygwin64\bin\mintty.exe -i /Cygwin-Terminal.ico -

$ java -version

java version "1.8.0_131"

echo $TERM

xterm

$ echo $BASH_VERSION

4.3.46(7)-release

After pressing arrow up 4 times, the cursor goes up 4 lines, as seen in the screenshot

pastedImage_0.png

I also tried to start it using cygwin.bat which contains:

@echo off

C:

chdir C:\cygwin64\bin

bash --login -i

this time, arrow up does nothing.

I have nothing in .bash_profile, or any other init scripts.

Thank you,

Calin

1 - 2

Post Details

Added on Sep 23 2021
5 comments
246 views