ORDS 25.1 ORDS_SECURITY vs OAUTH
PLSQL Package ORDS_SECURITY is replacing OAUTH. In OAUTH, you can easily replace or generate a client secret and the value is visible in view ORDS_METADATA.USER_ORDS_CLIENTS, for example:
BEGIN
OAUTH.UPDATE_CLIENT_SECRET(
p_client_name => 'MY_CLIENT',
p_editing_user => 'MY_USER',
p_client_secret => 'aMYG-Ejb_MtBuxrzwqwbuQ..');
END;
/
- What is the equivalent process to do this with ORDS_SECURITY?
- It looks like you can now set up two secrets?
- Will the client secret still be visible in ORDS_METADATA.USER_ORDS_CLIENTS once you use ORDS_SECURITY to generate a secret? When I tried it, a secret was returned but "*******" was in the ORDS_METADATA.USER_ORDS_CLIENTS view. The secret did work however when I tried to get a token.
0