Skip to Main Content

ORDS, SODA & JSON in the Database


For appeals, questions and feedback, please email

Read only access to ORDS objects in another schema


I would like to know how to achieve the below security feature in ORDS.

There is an existing schema owner “EMPLOYEE” that has bunch of ORDS services. We have a requirement to create another user/schema (EMPLOYEE_RO) to only have read-only access to the ORDS services from “EMPLOYEE”.

Is there a built in package/role to have read only access granted to EMPLOYEE_RO for EMPLOYEE ORDS services.

We tried giving below grant to EMPLOYEE_RO but EMPOYEE_RO could not still access (see) the ORDS services.

grant ords_adminstrator_role to EMPLOYEE_RO

Any help is highly appreciated.


Post Details
Added on Apr 1 2024
1 comment