1 Reply Latest reply on Jun 24, 2020 2:50 PM by thatJeffSmith-Oracle

set_identifier. prehook? schema user?

Orkan Jun 24, 2020 9:58 AM

Hey community,

I've set up ORDS without APEX and can make GET and POST calls for a sample table.

The goal ist to make those calls on a view, whose content dependents on the user that is connected to DB.

User A gets different content for a call than user B.

How can I accomplish making calls with a db user rather then the connection pool user?

I could not find anything in the oracle docs.

Regards,

Orkan

1. Re: set_identifier. prehook? schema user?

thatJeffSmith-Oracle Jun 24, 2020 2:50 PM (in response to Orkan)

So you want to have a rest service defined in schema b, but when called, actually gets executed as user a?

the rest services need to be defined in the schema you want them to ultimately run as
Like Show 0 Likes(0)

Actions