Oracle Rest Data Services (ORDS) (MOSC)

MOSC Banner

User on File-Based User Repository cannot access protected URL

Working on ORDS 23.1 and testing File-Based User Repository. Noticed that is not working as expected. Need help on what I'm doing wrong.

I have a database table employees under my ORDS enabled schema.

I rest enabled this table and I can access the data through URL https://hostname:8091/ords/ws/employees/

I created 1 role emp_role.

I created 1 privilege emp_priv under emp_role. The privilege is protecting pattern /employees/*

Now getting Error 401 Unauthorized when trying to access https://hostname:8091/ords/ws/employees/

I create a new File-based user "./ords --config /home/oracle/config/dbname config user add dhman emp_role" with password=pass. This user is a member of emp_role.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center