2 Risposte
- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
1
Hi there!
The master user in RDS Oracle should be direct-granted execute privileges on SYS.UTL_RECOMP, so it can grant the privilege to other users via the GRANT statement. For example,
grant execute on sys.utl_recomp to otheruser;
It can also be granted using the RDSADMIN_UTIL package as described at https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.Oracle.CommonDBATasks.System.html#Appendix.Oracle.CommonDBATasks.TransferPrivileges (note, you will need to specify the grantee username in upper case with this command).
exec rdsadmin.rdsadmin_util.grant_sys_object('UTL_RECOMP', 'OTHERUSER', 'EXECUTE');
Hope this helps. Thanks!
Michael
con risposta 5 anni fa
0
Thanks Michael, sometimes I get so deep in the weeds I cannot see the answer.
Appreciated.
con risposta 5 anni fa
Contenuto pertinente
- AWS UFFICIALEAggiornata 7 mesi fa
- AWS UFFICIALEAggiornata un anno fa