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!

Associate an ORDS client id with a database user id

RLOGFeb 20 2018 — edited Apr 3 2018

I have a POST request setup through ORDS which allows a supplier to send a data to the database via JSON and have it added to a sales table. I control access to the request via OAuth2. At present the supplier has to have a field in their data with their seller_id, but I'd like to control this through the db ideally to make it more secure. Is it possible to associate a client key with a user id from the database, and have that field automatically populated when the supplier posts their data? I assume I would do this by adding an extra field in the users table which includes the client_id, but I'm not sure how I'd then pass the client id into my procedure call when they post. Can anyone advise?

Thanks

Ross

Locked Post

New comments cannot be posted to this locked post.

Locked on May 1 2018

Added on Feb 20 2018

2 comments

653 views