ORDS ORA-01031: insufficient privileges-CodePudding

During installation, ORDS created a TEST user and granted rights, according to the instructions

1.3.4.1 ORDS Installer Privileges Script.

Issued the appropriate rights. But when trying to enable AUTOREST with (under user TEST):

BEGIN

     ORDS.ENABLE_OBJECT(p_enabled => TRUE,
                        p_schema => 'MAIN',
                        p_object => 'SOME_TABLE',
                        p_object_type => 'TABLE',
                        p_object_alias => 'some_table',
                        p_auto_rest_auth => FALSE);
     commit;
END;

I get:

[Error] Execution (49:1): ORA-01031: insufficient privileges
ORA-06512: at "ORDS_METADATA.ORDS", line 310
ORA-06512: at line 3

Oracle 11.2.0.4

ORDS latest

APEX 20.02

CodePudding user response：

You have to use the ORDS_ADMIN package to enable a schema or object other than your own.

To use this package, your user needs the ORDS Administrator role.

So, do this

GRANT ORDS_ADMINISTRATOR_ROLE TO HR_ADMIN;

Then login as TEST and run this

BEGIN

     ORDS_ADMIN.ENABLE_OBJECT(p_enabled => TRUE,
                        p_schema => 'MAIN',
                        p_object => 'SOME_TABLE',
                        p_object_type => 'TABLE',
                        p_object_alias => 'some_table',
                        p_auto_rest_auth => FALSE);
     commit;
END;

Disclaimer: I work for Oracle and am a product manager on the database team and cover ORDS.