Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Insufficient privilege to grant SELECT on DBA_ORDS_% views in Autonomous DB - Free Tier

klacey4 days ago

OCI Free Tier

Autonomous Transactional DB - Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.29.0.1.0

ORDS - 25.2.3.r2241517

Logged in as admin user to DB (tried OCI SQL Console, SQL Developer 24.3.1 and SQLcl 25.2 just to be sure)

grant select on DBA_ORDS_HANDLERS to a_schema;

ORA-01031: insufficient privileges

Is there a way to get around this? I can't log on as SYS (is this even possible on Autonomous? Don't have a sys password and don't see a way to change the sys password even though sys is an open user on the db covered by a password - admin cant do this)

Am I missing something obvious? (and apologies if this has been covered before.. I did search but drew a blank)

This post has been answered by thatJeffSmith-Oracle on Oct 2 2025
Jump to Answer
Comments
Post Details
Added 4 days ago
8 comments
52 views