We have organized our DB in different schemas, something like CARS, HOUSES, OWNERS, etc.
Now, we need that our oAuth Clients, could perform actions by using our REST services, in one or more SCHEMAS.
I ve already assign role to client, but it is not working...
BEGIN
oauth.grant_client_role (
p_client_name => 'INSURANCECLIENT',
p_role_name => 'oracle.dbtools.role.autorest.CARS.BRANDS'
);
commit;
END;
Where CARS is the schema, and BRANDS the AutoREST enabled table.
Then if I execute query:
SELECT * FROM USER_ORDS_CLIENT_ROLES WHERE CLIENT_NAME LIKE '%INSURANCECLIENT%';
the CARS.BRANDS role, is not being shown.