Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Read only access to ORDS objects in another schema

Hi,

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.

Thankyou.

Comments
Post Details
Added on Apr 1 2024
1 comment
92 views