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年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ