Can't grant execute grant with rdsadmin.rdsadmin_util.grant_sys_object over SYS.VALIDATE_APEX

0

I need to execute sys.validate_apex in order to make SPATIAL works on Oracle APEX. I tried the following code:

begin
    rdsadmin.rdsadmin_util.grant_sys_object(
        p_obj_name  => 'VALIDATE_APEX',
        p_grantee   => 'SNW_SYSTEM',
        p_privilege => 'EXECUTE');
end;
/

With the consequent error:

Error report -
ORA-20199: Error in rdsadmin_util.grant_sys_object. ORA-20900: You do not have permission to grant: EXECUTE to SYS object: VALIDATE_APEX
ORA-06512: at "RDSADMIN.RDSADMIN_UTIL", line 255
ORA-20900: You do not have permission to grant: EXECUTE to SYS object: VALIDATE_APEX
ORA-06512: at "SYS.RDS_SYS_UTIL", line 513
ORA-06512: at "RDSADMIN.RDSADMIN_UTIL", line 252

The root problem is caused by adding SPATIAL option after APEX-DEV option.

Any page in my apex applictaion related to SPATIAL datatypes returns error:

ORA-06592: No se ha encontrado la opción CASE al ejecutar la sentencia CASE

I tried editing the Option parameter group so it could trigger the procedure without success.

Any help is welcome. Thanks!

已提问 1 年前512 查看次数
1 回答
0

As the error message you dont have permission to grant i would suggest opening a case with aws premium support from support center to find out if it is allowed and what is the right way of achieving this

AWS
已回答 1 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则