I am currently working with a team to develop Oracle REST Data Services (ORDS), and each team member has a standard Oracle user account. We need to create and modify webservices for another schema in the Oracle Database.
I understand that this might require certain permissions or settings to be adjusted for each user, but I'm not entirely sure what these adjustments are. I also know that we need to manage the collaborative development process effectively so that everyone can work on the same RESTful services without conflict.
Could anyone help clarify the following for me:
- What roles or privileges do our Oracle users need to have to develop ORDS webservices for another schema?
- Are there any specific ORDS settings or configurations that need to be adjusted to allow multiple users to work on the same services?
- How can we effectively manage the development process so that all team members can collaborate on the same RESTful services?
Any insights or suggestions would be highly appreciated.
Thank you in advance!
can collaborate on the same RESTful services?
Answer 1 - the ORDS_ADMINISTRATOR_ROLE (Docs). If your user is granted this, they can execute the ORDS_ADMIN PL/SQL API (Docs). This allows you to publish REST APIs for ANY ORDS enabled schema/user in the database.
Answer 2 - No, just sort #1
Answer 3 - The same you would do with your PL/SQL programs. Use SOURCE CONTROL to manage the PL/SQL definitions of your APIs, and/or use SQLcl with Liquibase changeLogs for your REST APIs - those would also be put under source control.