2 réponses
- Le plus récent
- Le plus de votes
- La plupart des commentaires
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
répondu il y a 5 ans
0
Thanks Michael, sometimes I get so deep in the weeds I cannot see the answer.
Appreciated.
répondu il y a 5 ans
Contenus pertinents
- demandé il y a un an
- demandé il y a un an
- demandé il y a 2 mois
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a 6 mois