Bump. Has anyone done this before?
I suppose an alternative would be to change the endpoint to include the supplier name as part of the path in the handler, and then associate each client with their individual endpoint. Does that make more sense?
I'm looking at the same type of issue trying to link the OAuth user to a database user.
I think I have an approach that can work.
If you do the oauth.create_client with the p_name equal to the users oracle username which is to be given access.
Then in the PL/SQL you can reference the special bind variable of :current_user which will give you the OAuth client_id. Which gives you a value like KiTWLLitA9WCVE84Jj8kCA..
Then you can query back against the user_ords_clients table to get back to the registered name which will be the oracle username.
WHERE client_id = 'KiTWLLitA9WCVE84Jj8kCA..'
From my prototyping it seems to work correctly.
Let me know what you think.