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!

posta un anno fa512 visualizzazioni
1 Risposta
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
con risposta un anno fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande