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!

gefragt vor einem Jahr512 Aufrufe
1 Antwort
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
beantwortet vor einem Jahr

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen