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