Hello,
in traditinal oracle db, we can do: REVOKE EXECUTE ON DBMS_LDAP FROM PUBLIC;
In AWS RDS oracle db
begin
rdsadmin.rdsadmin_util.revoke_sys_object(
p_obj_name => 'DBMS_LDAP',
p_revokee => 'PUBLIC',
p_privilege => 'EXECUTE');
end;
/
ERROR at line 1:
ORA-20199: Error in rdsadmin_util.revoke_sys_object. ORA-20900: Revoking
privilege from PUBLIC is not allowed.
ORA-06512: at "RDSADMIN.RDSADMIN_UTIL", line 266
ORA-20900: Revoking privilege from PUBLIC is not allowed.
ORA-06512: at "SYS.RDS_SYS_UTIL", line 420
ORA-06512: at "RDSADMIN.RDSADMIN_UTIL", line 263
ORA-06512: at line 2
Anything I can do to fix this
Thanks