Oracle Rest Data Services (ORDS) (MOSC)

MOSC Banner

Privilege issues - ORA-20012: Schema not REST enabled : SYS

Hi Team

I wish to create a role inside an oracle pluggable database using 'SYS' user.

BEGIN

ords.create_role(p_role_name => 'job_scheduler_role');

COMMIT;
END;

Error

====

DECLARE
*
ERROR at line 1:
ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "ORDS_METADATA.ORDS", line 1
ORA-06512: at line 6

Step 2: Granted the following and tried again.

grant inherit privileges on user sys to ords_metadata;

Error report -
ORA-20012: Schema not REST enabled : SYS
ORA-06512: at "ORDS_METADATA.ORDS", line 731
ORA-06512: at "ORDS_METADATA.ORDS_SECURITY", line 239
ORA-06512: at "ORDS_METADATA.ORDS_SECURITY", line 227
ORA-06512: at "ORDS_METADATA.ORDS", line 75
ORA-06512: at "ORDS_METADATA.ORDS", line 718

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center